Java Examples for org.apache.poi.POIXMLProperties
The following java examples will help you to understand the usage of org.apache.poi.POIXMLProperties. These source code samples are taken from different open source projects.
Example 1
Project: qcadoo-master File: AbstractXLSXView.java View source code |
/** * Renders the Excel view, given the specified model. */ @Override protected final void renderMergedOutputModel(Map<String, Object> model, HttpServletRequest request, HttpServletResponse response) throws Exception { XSSFWorkbook workbook; ByteArrayOutputStream baos = createTemporaryOutputStream(); workbook = new XSSFWorkbook(); POIXMLProperties xmlProps = workbook.getProperties(); POIXMLProperties.CoreProperties coreProps = xmlProps.getCoreProperties(); coreProps.setCreator(CREATOR); buildExcelDocument(model, workbook, request, response); workbook.write(baos); writeToResponse(response, baos); }
Example 2
Project: poi-master File: TestXSSFBugs.java View source code |
@Test public void bug54764() throws IOException, OpenXML4JException, XmlException { OPCPackage pkg = XSSFTestDataSamples.openSamplePackage("54764.xlsx"); // Check the core properties - will be found but empty, due // to the expansion being too much to be considered valid POIXMLProperties props = new POIXMLProperties(pkg); assertEquals(null, props.getCoreProperties().getTitle()); assertEquals(null, props.getCoreProperties().getSubject()); assertEquals(null, props.getCoreProperties().getDescription()); // Now check the spreadsheet itself try { new XSSFWorkbook(pkg).close(); fail("Should fail as too much expansion occurs"); } catch (POIXMLException e) { } pkg.close(); // Try with one with the entities in the Content Types try { XSSFTestDataSamples.openSamplePackage("54764-2.xlsx").close(); fail("Should fail as too much expansion occurs"); } catch (Exception e) { } // Check we can still parse valid files after all that Workbook wb = XSSFTestDataSamples.openSampleWorkbook("sample.xlsx"); assertEquals(3, wb.getNumberOfSheets()); wb.close(); }
Example 3
Project: constellio-master File: OfficeDocumentsServices.java View source code |
public void setPropertyNewDocument(String ext, StreamFactory<InputStream> inputStreamFactory, StreamFactory<OutputStream> outputStreamFactory, String propertyName, String propertyValue) throws IOException, PropertyDoesntExist, NotCompatibleExtension, CannotReadDocumentsProperties { POIXMLDocument doc = parseDocument(ext, inputStreamFactory, propertyName); org.apache.poi.POIXMLProperties.CustomProperties customProperties = doc.getProperties().getCustomProperties(); int index = 0; for (CTProperty prop : customProperties.getUnderlyingProperties().getPropertyList()) { if (prop.getName().equals(propertyName)) { customProperties.getUnderlyingProperties().removeProperty(index); } index++; } customProperties.addProperty(propertyName, propertyValue); doc.write(outputStreamFactory.create(getClass().getName() + ".setPropertyNewDocument")); }
Example 4
Project: railo-master File: Excel.java View source code |
public Struct getSummaryInfo() { Struct infostruct = new StructImpl(); int sheets = workbook.getNumberOfSheets(); infostruct.setEL("SHEETS", new Double(sheets)); if (sheets > 0) { StringBuilder sb = new StringBuilder(); for (int i = 0; i < sheets; i++) { if (i > 0) sb.append(','); sb.append(workbook.getSheetName(i)); } infostruct.setEL("SHEETNAMES", sb.toString()); } if (xmlFormat == FORMAT_HSSF) { infostruct.setEL("SPREADSHEETTYPE", "Excel"); HSSFWorkbook hssfworkbook = (HSSFWorkbook) workbook; info(infostruct, hssfworkbook.getSummaryInformation()); info(infostruct, hssfworkbook.getDocumentSummaryInformation()); } else if (xmlFormat == FORMAT_XSSF) { infostruct.put("SPREADSHEETTYPE", "Excel (2007)"); XSSFWorkbook xssfworkbook = (XSSFWorkbook) workbook; POIXMLProperties props = xssfworkbook.getProperties(); info(infostruct, props.getCoreProperties().getUnderlyingProperties()); info(infostruct, props.getExtendedProperties().getUnderlyingProperties()); } return infostruct; }
Example 5
Project: ktdocumentindexer-master File: KTMetaData.java View source code |
public java.util.Map<String, String> readOOXMLProperty(String fileName, int type, String keyName) { this.logger.debug("POI Properties - OOXML: Read metadata from file " + fileName); // Initialise result java.util.Hashtable result = new java.util.Hashtable(); java.util.Hashtable metadata = new java.util.Hashtable(); // Open the document POIXMLDocument poi_doc; try { this.logger.debug("POI Properties - OOXML: Open document stream"); // Use the extension to determine and initialise the correct document type switch(type) { case 1: this.logger.debug("POI Properties - OOXML: File is of type docx"); FileInputStream inStream = new FileInputStream(fileName); poi_doc = new XWPFDocument(inStream); inStream.close(); break; case 2: this.logger.debug("POI Properties - OOXML: File is of type xlsx"); poi_doc = new XSSFWorkbook(fileName); break; case 3: this.logger.debug("POI Properties - OOXML: File is of type pptx"); poi_doc = new XSLFSlideShow(fileName); break; default: this.logger.error("POI Properties - OOXML: Input file should be of type docx, xlsx or pptx."); result.put("status", "1"); result.put("metadata", metadata); return result; } } catch (Exception ex) { this.logger.error("POI Properties - OOXML: Input file could not be opened: " + ex.getMessage()); ex.printStackTrace(); result.put("status", "1"); result.put("metadata", metadata); return result; } // Read in the properties POIXMLProperties.CustomProperties customProps; try { this.logger.debug("POI Properties - OOXML: Read custom properties"); customProps = poi_doc.getProperties().getCustomProperties(); if (customProps == null) { this.logger.debug("POI Properties - OOXML: No custom properties have been defined."); result.put("status", "0"); result.put("metadata", metadata); return result; } org.openxmlformats.schemas.officeDocument.x2006.customProperties.CTProperties ctProps = poi_doc.getProperties().getCustomProperties().getUnderlyingProperties(); org.openxmlformats.schemas.officeDocument.x2006.customProperties.CTProperty p; int size = ctProps.sizeOfPropertyArray(); int count = 0; while (size != count) { p = ctProps.getPropertyArray(count); String key = p.getName(); if (key.equals(keyName)) { String value = p.getLpwstr(); metadata.put(key, value); this.logger.debug("POI Properties - OOXML: Custom property - name " + key + "; value " + value); } count++; } } catch (Exception ex) { this.logger.error("POI Properties - OOXML: Custom properties could not be found: " + ex.getMessage()); ex.printStackTrace(); result.put("status", "1"); result.put("metadata", metadata); return result; } result.put("status", "0"); result.put("metadata", metadata); return result; }
Example 6
Project: com.opendoorlogistics-master File: PoiIO.java View source code |
public static boolean exportDatastore(ODLDatastore<? extends ODLTableReadOnly> ds, File file, boolean xlsx, ProcessingApi processing, ExecutionReport report) { //tmpFileBugFix(); Workbook wb = null; SXSSFWorkbook sxssfwb = null; HSSFWorkbook hssfwb = null; if (xlsx == false) { hssfwb = new HSSFWorkbook(); hssfwb.createInformationProperties(); hssfwb.getSummaryInformation().setAuthor(AppConstants.ORG_NAME); wb = hssfwb; } else { // sxssfwb = new SXSSFWorkbook(100); // keep 100 rows in memory, exceeding rows will be flushed to disk sxssfwb = new SXSSFWorkbook(null, 100, false, true); wb = sxssfwb; // XSSFWorkbook xssfWorkbook = new XSSFWorkbook(); /// POIXMLProperties xmlProps = sxssfwb. //POIXMLProperties.CoreProperties coreProps = xmlProps.getCoreProperties(); // coreProps.setCreator(AppConstants.ORG_NAME); // wb = xssfWorkbook; } try { // save schema addSchema(ds, wb); for (ODLTableDefinition table : TableUtils.getAlphabeticallySortedTables(ds)) { ODLTableReadOnly tro = (ODLTableReadOnly) table; Sheet sheet = wb.createSheet(tro.getName()); if (sheet == null) { return false; } exportTable(sheet, tro, 0, processing, report); if (processing != null && processing.isCancelled()) { return false; } } if (processing != null) { processing.postStatusMessage("Saving whole workbook to disk."); } saveWorkbook(file, wb); } catch (Exception e) { throw new RuntimeException(e); } finally { if (sxssfwb != null) { sxssfwb.dispose(); } if (hssfwb != null) { try { hssfwb.close(); } catch (Exception e2) { } } } return true; }
Example 7
Project: OOXML-master File: XSSFWorkbook.java View source code |
/** * Create a new CTWorkbook with all values set to default */ private void onWorkbookCreate() { workbook = CTWorkbook.Factory.newInstance(); // don't EVER use the 1904 date system CTWorkbookPr workbookPr = workbook.addNewWorkbookPr(); workbookPr.setDate1904(false); CTBookViews bvs = workbook.addNewBookViews(); CTBookView bv = bvs.addNewWorkbookView(); bv.setActiveTab(0); workbook.addNewSheets(); POIXMLProperties.ExtendedProperties expProps = getProperties().getExtendedProperties(); expProps.getUnderlyingProperties().setApplication(DOCUMENT_CREATOR); sharedStringSource = (SharedStringsTable) createRelationship(XSSFRelation.SHARED_STRINGS, XSSFFactory.getInstance()); stylesSource = (StylesTable) createRelationship(XSSFRelation.STYLES, XSSFFactory.getInstance()); namedRanges = new ArrayList<XSSFName>(); sheets = new ArrayList<XSSFSheet>(); }
Example 8
Project: nextreports-engine-master File: XlsxExporter.java View source code |
private void createSummaryInformation(String title) { DateFormat df = new SimpleDateFormat("MM/dd/yyyy HH:mm:ss"); POIXMLProperties xmlProps = wb.getProperties(); POIXMLProperties.CoreProperties coreProps = xmlProps.getCoreProperties(); coreProps.setTitle(title); coreProps.setCreator(ReleaseInfoAdapter.getCompany()); coreProps.setDescription("NextReports " + ReleaseInfoAdapter.getVersionNumber()); xmlProps.getExtendedProperties().getUnderlyingProperties().setApplication("NextReports " + ReleaseInfoAdapter.getVersionNumber()); coreProps.setSubjectProperty("Created by NextReports Designer" + ReleaseInfoAdapter.getVersionNumber()); coreProps.setCreated(df.format(new Date())); coreProps.setKeywords(ReleaseInfoAdapter.getHome()); }
Example 9
Project: tika-master File: XSLFEventBasedPowerPointExtractor.java View source code |
public POIXMLProperties.CoreProperties getCoreProperties() { return this.properties.getCoreProperties(); }