List of usage examples for org.apache.poi.hpsf CustomProperties put
@Override
public Object put(String key, Object value)
From source file:edu.casetools.rcase.extensions.excel.control.Exporter.java
License:Open Source License
private void setDefaultProperties(String templateName) { HSSFWorkbook hworkbook = (HSSFWorkbook) this.workbook; hworkbook.createInformationProperties(); SummaryInformation si = hworkbook.getSummaryInformation(); DocumentSummaryInformation dsi = hworkbook.getDocumentSummaryInformation(); si.setAuthor(I18nMessageService.getString("Excel.Author")); dsi.setCompany(I18nMessageService.getString("Excel.Company")); si.setApplicationName(I18nMessageService.getString("Excel.Application")); org.apache.poi.hpsf.CustomProperties cp = dsi.getCustomProperties(); cp.put("Table Template", templateName); dsi.setCustomProperties(cp);/*from www . j a v a 2 s . co m*/ }
From source file:edu.ku.brc.specify.tasks.subpane.wb.XLSExport.java
License:Open Source License
/** * @param wbt/*from w ww.ja v a 2 s . c om*/ * @return DocumentSummaryInformation containing the mappings for wbt. * * Each mapping is stored as a property, using the column heading as the key. */ protected DocumentSummaryInformation writeMappings(final WorkbenchTemplate wbt) { DocumentSummaryInformation dsi = PropertySetFactory.newDocumentSummaryInformation(); CustomProperties cps = new CustomProperties(); List<WorkbenchTemplateMappingItem> wbmis = new ArrayList<WorkbenchTemplateMappingItem>( wbt.getWorkbenchTemplateMappingItems()); Collections.sort(wbmis, new Comparator<WorkbenchTemplateMappingItem>() { /* (non-Javadoc) * @see java.util.Comparator#compare(java.lang.Object, java.lang.Object) */ @Override public int compare(WorkbenchTemplateMappingItem arg0, WorkbenchTemplateMappingItem arg1) { // TODO Auto-generated method stub return arg0.getViewOrder().compareTo(arg1.getViewOrder()); } }); for (WorkbenchTemplateMappingItem wbmi : wbmis) { //cps.put(wbmi.getCaption(), //cps.put(wbmi.getTableName() + "." + wbmi.getFieldName(), cps.put(ConfigureXLS.POIFS_COL_KEY_PREFIX + wbmi.getViewOrder(), wbmi.getCaption() + "\t" + wbmi.getTableName() + "\t" + wbmi.getFieldName() + "\t" + wbmi.getXCoord() + "\t" + wbmi.getYCoord() + "\t" + wbmi.getCaption() + "\t" + wbmi.getFieldType() + "\t" + wbmi.getMetaData()); } dsi.setCustomProperties(cps); return dsi; }
From source file:org.eclipse.scada.ae.ui.views.export.excel.impl.ExportEventsImpl.java
License:Open Source License
private void makeDocInfo(final HSSFWorkbook workbook) { workbook.createInformationProperties(); final DocumentSummaryInformation dsi = workbook.getDocumentSummaryInformation(); dsi.setCompany("Eclipse SCADA Project"); final CustomProperties cp = new CustomProperties(); cp.put("Eclipse SCADA Export Version", Activator.getDefault().getBundle().getVersion().toString()); dsi.setCustomProperties(cp);//from w w w.j a va2s. c om }
From source file:org.openscada.ae.ui.views.export.excel.impl.ExportEventsImpl.java
License:Open Source License
private void makeDocInfo(final HSSFWorkbook workbook) { workbook.createInformationProperties(); final DocumentSummaryInformation dsi = workbook.getDocumentSummaryInformation(); dsi.setCompany("TH4 SYSTEMS GmbH"); final CustomProperties cp = new CustomProperties(); cp.put("openSCADA Export Version", Activator.getDefault().getBundle().getVersion().toString()); dsi.setCustomProperties(cp);/*from w w w. j a v a2 s . co m*/ }
From source file:org.redpill.alfresco.module.metadatawriter.services.msoffice.impl.POIFSFacadeImpl.java
License:Open Source License
public void setCustomMetadata(final String field, final String value) throws ContentException { if (logger.isDebugEnabled()) { logger.debug("Exporting metadata " + field + "=" + value); }//from ww w . j a v a 2s. c o m final CustomProperties customProperties = getCustomProperties(); // if(logger.isDebugEnabled()) { // logger.debug("CustomProperties before export: " + // describe(customProperties)); // } customProperties.put(field, value); getDocumentSummaryInformation().setCustomProperties(customProperties); saveDocumentSummaryInformation(); // if(logger.isDebugEnabled()) { // logger.debug("CustomProperties after export: " + // describe(getCustomProperties())); // } }
From source file:poi.hpsf.examples.ModifyDocumentSummaryInformation.java
License:Apache License
/** * <p>Main method - see class description.</p> * * @param args The command-line parameters. * @throws java.io.IOException//from w w w . jav a 2s.c o m * @throws MarkUnsupportedException * @throws NoPropertySetStreamException * @throws UnexpectedPropertySetTypeException * @throws WritingNotSupportedException */ public static void main(final String[] args) throws IOException, NoPropertySetStreamException, MarkUnsupportedException, UnexpectedPropertySetTypeException, WritingNotSupportedException { /* Read the name of the POI filesystem to modify from the command line. * For brevity to boundary check is performed on the command-line * arguments. */ File poiFilesystem = new File(args[0]); /* Open the POI filesystem. */ InputStream is = new FileInputStream(poiFilesystem); POIFSFileSystem poifs = new POIFSFileSystem(is); is.close(); /* Read the summary information. */ DirectoryEntry dir = poifs.getRoot(); SummaryInformation si; try { DocumentEntry siEntry = (DocumentEntry) dir.getEntry(SummaryInformation.DEFAULT_STREAM_NAME); DocumentInputStream dis = new DocumentInputStream(siEntry); PropertySet ps = new PropertySet(dis); dis.close(); si = new SummaryInformation(ps); } catch (FileNotFoundException ex) { /* There is no summary information yet. We have to create a new * one. */ si = PropertySetFactory.newSummaryInformation(); } /* Change the author to "Rainer Klute". Any former author value will * be lost. If there has been no author yet, it will be created. */ si.setAuthor("Rainer Klute"); System.out.println("Author changed to " + si.getAuthor() + "."); /* Handling the document summary information is analogous to handling * the summary information. An additional feature, however, are the * custom properties. */ /* Read the document summary information. */ DocumentSummaryInformation dsi; try { DocumentEntry dsiEntry = (DocumentEntry) dir.getEntry(DocumentSummaryInformation.DEFAULT_STREAM_NAME); DocumentInputStream dis = new DocumentInputStream(dsiEntry); PropertySet ps = new PropertySet(dis); dis.close(); dsi = new DocumentSummaryInformation(ps); } catch (FileNotFoundException ex) { /* There is no document summary information yet. We have to create a * new one. */ dsi = PropertySetFactory.newDocumentSummaryInformation(); } /* Change the category to "POI example". Any former category value will * be lost. If there has been no category yet, it will be created. */ dsi.setCategory("POI example"); System.out.println("Category changed to " + dsi.getCategory() + "."); /* Read the custom properties. If there are no custom properties yet, * the application has to create a new CustomProperties object. It will * serve as a container for custom properties. */ CustomProperties customProperties = dsi.getCustomProperties(); if (customProperties == null) customProperties = new CustomProperties(); /* Insert some custom properties into the container. */ customProperties.put("Key 1", "Value 1"); customProperties.put("Schl\u00fcssel 2", "Wert 2"); customProperties.put("Sample Number", new Integer(12345)); customProperties.put("Sample Boolean", Boolean.TRUE); customProperties.put("Sample Date", new Date()); /* Read a custom property. */ Object value = customProperties.get("Sample Number"); /* Write the custom properties back to the document summary * information. */ dsi.setCustomProperties(customProperties); /* Write the summary information and the document summary information * to the POI filesystem. */ si.write(dir, SummaryInformation.DEFAULT_STREAM_NAME); dsi.write(dir, DocumentSummaryInformation.DEFAULT_STREAM_NAME); /* Write the POI filesystem back to the original file. Please note that * in production code you should never write directly to the origin * file! In case of a writing error everything would be lost. */ OutputStream out = new FileOutputStream(poiFilesystem); poifs.writeFilesystem(out); out.close(); }