Example usage for org.apache.poi.hssf.usermodel HSSFWorkbook createInformationProperties

List of usage examples for org.apache.poi.hssf.usermodel HSSFWorkbook createInformationProperties

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.hssf.usermodel.*
  5. HSSFWorkbook
  6. createInformationProperties

Introduction

In this page you can find the example usage for org.apache.poi.hssf.usermodel HSSFWorkbook createInformationProperties.

Prototype

public void createInformationProperties()

Source Link

Document

Will create whichever of SummaryInformation and DocumentSummaryInformation (HPSF) properties are not already part of your document.

Usage

From source file:com.opendoorlogistics.core.tables.io.PoiIO.java

License:Open Source License

public static boolean exportDatastore(ODLDatastore<? extends ODLTableReadOnly> ds, File file, boolean xlsx,
        ProcessingApi processing, ExecutionReport report) {
    //tmpFileBugFix();

    Workbook wb = null;/*from w  ww .j av a 2s.co m*/
    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) {
                // TODO: handle exception
            }
        }
    }

    return true;
}

From source file:com.xhsoft.framework.common.file.ExcelHandle.java

License:Open Source License

public void setDocInfo(HSSFWorkbook xls) {
    xls.createInformationProperties(); //?
    SummaryInformation si = xls.getSummaryInformation();
    //si.setTitle(title);
    //si.setSubject(subject);

    //si.setComments(comments);

    //si.setAuthor(author);
    //si.setApplicationName(appName);

}

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  w  w w .j a  v a2s.  c om
}

From source file:gov.nih.nci.evs.app.neopl.XLSMetadataUtils.java

License:Open Source License

public static void setAuthor(String filename, String author) {
    HSSFWorkbook workbook = null;
    FileInputStream fis = null;/*from   w  ww . j  a va 2s.  c o m*/
    try {
        System.out.println(filename);
        fis = new FileInputStream(filename);
        workbook = new HSSFWorkbook(fis);
        workbook.createInformationProperties();
        SummaryInformation summaryInfo = workbook.getSummaryInformation();
        summaryInfo.setAuthor(author);

    } catch (Exception ex) {
        ex.printStackTrace();
    } finally {
        try {
            fis.close();
        } catch (Exception ex) {

        }
    }
    FileOutputStream fos = null;

    try {
        fos = new FileOutputStream(new File(filename));
        workbook.write(fos);
        fos.flush();
    } catch (Exception ex) {
        ex.printStackTrace();
    } finally {
        try {
            fos.close();
            System.out.println("Outputfile " + filename + " generated.");
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
}

From source file:gov.nih.nci.evs.app.neopl.XLSXMetadataUtils.java

License:Open Source License

public static void setSummaryData(String filename, String[] keys, String[] values) {
    String size = getFileSize(filename);
    FileInputStream stream = null;
    try {//from  w w  w . j av a 2  s  .c  o m
        stream = new FileInputStream(new File(filename));
        POIFSFileSystem poifs = null;
        boolean passed = false;
        try {
            poifs = new POIFSFileSystem(stream);
            passed = true;
        } catch (Exception e) {
            passed = false;
        }
        if (!passed) {
            setPOISummaryData(filename, keys, values);
            stream.close();
            return;
        }

        HSSFWorkbook workbook = null;
        SummaryInformation summaryInfo = null;
        FileInputStream fis = null;
        try {
            System.out.println(filename);
            fis = new FileInputStream(filename);

            workbook = new HSSFWorkbook(fis);
            summaryInfo = workbook.getSummaryInformation();
            if (summaryInfo == null) {
                workbook.createInformationProperties();
                summaryInfo = workbook.getSummaryInformation();

                for (int i = 0; i < keys.length; i++) {
                    String key = keys[i];
                    String value = values[i];

                    System.out.println(key + " -> " + value);

                    if (key.compareTo(SUMMARY_DATA_AUTHOR) == 0) {
                        summaryInfo.setAuthor(value);
                    } else if (key.compareTo(SUMMARY_DATA_KEYWORDS) == 0) {
                        summaryInfo.setKeywords(value);
                    } else if (key.compareTo(SUMMARY_DATA_TITLE) == 0) {
                        summaryInfo.setTitle(value);
                    } else if (key.compareTo(SUMMARY_DATA_SUBJECT) == 0) {
                        summaryInfo.setSubject(value);
                    }
                }

            }
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            try {
                fis.close();
            } catch (Exception ex) {

            }
        }
        FileOutputStream fos = null;

        try {
            fos = new FileOutputStream(new File(filename));
            workbook.write(fos);
            fos.flush();
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            fos.close();
        }

    } catch (Exception ex) {
        ex.printStackTrace();
    }
}

From source file:mat.server.service.impl.XLSGenerator.java

/** Creates the meta data.
 * /*from  w  ww .  jav  a2s . c o  m*/
 * @param wkbk - HSSFWorkbook.
 * 
 *        * */
public final void createMetaData(final HSSFWorkbook wkbk) {
    // Author: eMeasureTool, Title: Value Set Export, Subject: Value Set
    // Export, Keywords: Value Set, OID, Export, Measure, Code, Descriptor
    wkbk.createInformationProperties();
    SummaryInformation si = wkbk.getSummaryInformation();
    si.setAuthor(AUTHOR);
    si.setTitle(TITLE);
    si.setSubject(SUBJECT);
    si.setKeywords(KEYWORDS);
}

From source file:org.alanwilliamson.openbd.plugin.spreadsheet.functions.SpreadsheetAddInfo.java

License:Open Source License

public cfData execute(cfSession _session, List<cfData> parameters) throws cfmRunTimeException {
    if (parameters.get(0).getDataType() != cfData.CFSTRUCTDATA)
        throwException(_session, "parameter must be of type structure");

    cfSpreadSheetData spreadsheet = (cfSpreadSheetData) parameters.get(1);
    cfStructData s = (cfStructData) parameters.get(0);

    Workbook workbook = spreadsheet.getWorkBook();

    /*/*w ww  .j a v  a2s  .co m*/
     * XSSFWorkbook
     */
    if (workbook instanceof XSSFWorkbook) {
        XSSFWorkbook xSSFWorkbook = (XSSFWorkbook) workbook;

        CoreProperties cP = xSSFWorkbook.getProperties().getCoreProperties();

        if (s.containsKey("author"))
            cP.setCreator(s.getData("author").getString());
        if (s.containsKey("category"))
            cP.setCategory(s.getData("category").getString());
        if (s.containsKey("subject"))
            cP.setSubjectProperty(s.getData("subject").getString());
        if (s.containsKey("title"))
            cP.setTitle(s.getData("title").getString());
        if (s.containsKey("revision"))
            cP.setRevision(s.getData("revision").getString());
        if (s.containsKey("description"))
            cP.setDescription(s.getData("description").getString());

    } else {
        HSSFWorkbook hSSFWorkbook = (HSSFWorkbook) workbook;
        DocumentSummaryInformation dSummary = hSSFWorkbook.getDocumentSummaryInformation();

        if (dSummary == null) {
            hSSFWorkbook.createInformationProperties();
            dSummary = hSSFWorkbook.getDocumentSummaryInformation();
        }

        if (s.containsKey("category"))
            dSummary.setCategory(s.getData("category").getString());
        if (s.containsKey("manager"))
            dSummary.setManager(s.getData("manager").getString());
        if (s.containsKey("company"))
            dSummary.setCompany(s.getData("company").getString());

        SummaryInformation sInformation = hSSFWorkbook.getSummaryInformation();

        if (s.containsKey("title"))
            sInformation.setTitle(s.getData("title").getString());
        if (s.containsKey("subject"))
            sInformation.setSubject(s.getData("subject").getString());
        if (s.containsKey("author"))
            sInformation.setAuthor(s.getData("author").getString());
        if (s.containsKey("comments"))
            sInformation.setComments(s.getData("comments").getString());
        if (s.containsKey("keywords"))
            sInformation.setKeywords(s.getData("keywords").getString());
        if (s.containsKey("lastauthor"))
            sInformation.setLastAuthor(s.getData("lastauthor").getString());
    }

    return cfBooleanData.TRUE;
}

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);// w ww.  j a v  a 2  s. c  o  m
}

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);/*  ww  w .  j a  v a  2 s. c o m*/
}

From source file:se.mithlond.services.content.impl.ejb.report.ExcelReportServiceBean.java

License:Apache License

/**
 * {@inheritDoc}/* w  ww  .  j  a  v a  2  s .  c o  m*/
 */
@Override
public Workbook createDocument(@NotNull final Membership activeMembership, @NotNull final String title) {

    // Check sanity
    Validate.notNull(activeMembership, "activeMembership");

    final HSSFWorkbook toReturn = new HSSFWorkbook();
    toReturn.createInformationProperties();

    // Add some comments.
    final SummaryInformation summaryInformation = toReturn.getSummaryInformation();
    summaryInformation.setCreateDateTime(new Date());
    summaryInformation.setTitle(title);
    summaryInformation.setAuthor("Nazgl Services Excel Report Generator");
    summaryInformation.setSubject("Requested by: " + activeMembership.getAlias());
    summaryInformation.setRevNumber("1");

    // Add some Document summary information as well.
    final DocumentSummaryInformation documentSummaryInformation = toReturn.getDocumentSummaryInformation();
    final String orgName = activeMembership.getOrganisation().getOrganisationName();
    documentSummaryInformation.setCompany(activeMembership.getOrganisation().getOrganisationName());
    documentSummaryInformation.setManager(orgName + " is Da Boss of you!");

    // All Done.
    return toReturn;
}