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();
}