Package org.apache.poi

Examples of org.apache.poi.POIXMLProperties

291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
   *  Test setting of core properties such as Title and Author
   */
    @Test
  public void workbookProperties() {
    XSSFWorkbook workbook = new XSSFWorkbook();
    POIXMLProperties props = workbook.getProperties();
    assertNotNull(props);
    //the Application property must be set for new workbooks, see Bugzilla #47559
    assertEquals("Apache POI", props.getExtendedProperties().getUnderlyingProperties().getApplication());

    PackagePropertiesPart opcProps = props.getCoreProperties().getUnderlyingProperties();
    assertNotNull(opcProps);

    opcProps.setTitleProperty("Testing Bugzilla #47460");
    assertEquals("Apache POI", opcProps.getCreatorProperty().getValue());
    opcProps.setCreatorProperty("poi-dev@poi.apache.org");
View Full Code Here
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
  /**
   *  Test setting of core properties such as Title and Author
   */
  public void testWorkbookProperties() {
    XSSFWorkbook workbook = new XSSFWorkbook();
    POIXMLProperties props = workbook.getProperties();
    assertNotNull(props);
    //the Application property must be set for new workbooks, see Bugzilla #47559
    assertEquals("Apache POI", props.getExtendedProperties().getUnderlyingProperties().getApplication());

    PackagePropertiesPart opcProps = props.getCoreProperties().getUnderlyingProperties();
    assertNotNull(opcProps);

    opcProps.setTitleProperty("Testing Bugzilla #47460");
    assertEquals("Apache POI", opcProps.getCreatorProperty().getValue());
    opcProps.setCreatorProperty("poi-dev@poi.apache.org");
View Full Code Here
70
71
72
73
74
75
76
    }
    public XSSFEventBasedExcelExtractor(OPCPackage container) throws XmlException, OpenXML4JException, IOException {
        super(null);
        this.container = container;

        properties = new POIXMLProperties(container);
    }
View Full Code Here
1852
1853
1854
1855
1856
1857
1858
1859
1860
1861
1862
1863
1864
1865
    public void bug54764() throws Exception {
        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);
            fail("Should fail as too much expansion occurs");
View Full Code Here
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
  /**
   *  Test setting of core properties such as Title and Author
   */
  public void testWorkbookProperties() {
    XSSFWorkbook workbook = new XSSFWorkbook();
    POIXMLProperties props = workbook.getProperties();
    assertNotNull(props);
    //the Application property must be set for new workbooks, see Bugzilla #47559
    assertEquals("Apache POI", props.getExtendedProperties().getUnderlyingProperties().getApplication());

    PackagePropertiesPart opcProps = props.getCoreProperties().getUnderlyingProperties();
    assertNotNull(opcProps);

    opcProps.setTitleProperty("Testing Bugzilla #47460");
    assertEquals("Apache POI", opcProps.getCreatorProperty().getValue());
    opcProps.setCreatorProperty("poi-dev@poi.apache.org");
View Full Code Here
84
85
86
87
88
89
90
91
92
    assertEquals(" ", xml.getProperties().getCoreProperties().getUnderlyingProperties().getSubjectProperty().getValue());
  }

  public void testWorkbookProperties() {
    XWPFDocument doc = new XWPFDocument();
    POIXMLProperties props = doc.getProperties();
    assertNotNull(props);
    assertEquals("Apache POI", props.getExtendedProperties().getUnderlyingProperties().getApplication());
  }
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
    public static void main(String[]args) throws Exception {

        XSSFWorkbook workbook = new XSSFWorkbook();
        workbook.createSheet("Workbook Properties");

        POIXMLProperties props = workbook.getProperties();

        /**
         * Extended properties are a predefined set of metadata properties
         * that are specifically applicable to Office Open XML documents.
         * Extended properties consist of 24 simple properties and 3 complex properties stored in the
         *  part targeted by the relationship of type
         */
        POIXMLProperties.ExtendedProperties ext =  props.getExtendedProperties();
        ext.getUnderlyingProperties().setCompany("Apache Software Foundation");
        ext.getUnderlyingProperties().setTemplate("XSSF");

        /**
         * Custom properties enable users to define custom metadata properties
         * through a set of well-defined data types. For example, a custom
         * OLE Editor property of type string can be defined as follows:
         *
         *  <property fmtid="{D5CDD505-2E9C-101B-9397-08002B2CF9AE}" pid="2" name="Editor">
         *    <vt:lpwstr>John Smith</vt:lpwstr>
         *  </property>
         */
       
        POIXMLProperties.CustomProperties cust =  props.getCustomProperties();
        org.openxmlformats.schemas.officeDocument.x2006.customProperties.CTProperty
                property = cust.getUnderlyingProperties().addNewProperty();

        property.setFmtid("{D5CDD505-2E9C-101B-9397-08002B2CF9AE}");
        property.setPid(2);
View Full Code Here
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
  /**
   *  Test setting of core properties such as Title and Author
   */
  public void testWorkbookProperties() {
    XSSFWorkbook workbook = new XSSFWorkbook();
    POIXMLProperties props = workbook.getProperties();
    assertNotNull(props);
    //the Application property must be set for new workbooks, see Bugzilla #47559
    assertEquals("Apache POI", props.getExtendedProperties().getUnderlyingProperties().getApplication());

    PackagePropertiesPart opcProps = props.getCoreProperties().getUnderlyingProperties();
    assertNotNull(opcProps);

    opcProps.setTitleProperty("Testing Bugzilla #47460");
    assertEquals("Apache POI", opcProps.getCreatorProperty().getValue());
    opcProps.setCreatorProperty("poi-dev@poi.apache.org");
View Full Code Here
60
61
62
63
64
65
66
  }
  public XSSFEventBasedExcelExtractor(OPCPackage container) throws XmlException, OpenXML4JException, IOException {
    super(null);
    this.container = container;
   
    properties = new POIXMLProperties(container);
  }
View Full Code Here
88
89
90
91
92
93
94
95
96
    assertEquals(" ", xml.getProperties().getCoreProperties().getUnderlyingProperties().getSubjectProperty().getValue());
  }

  public void testWorkbookProperties() {
    XWPFDocument doc = new XWPFDocument();
    POIXMLProperties props = doc.getProperties();
    assertNotNull(props);
    assertEquals("Apache POI", props.getExtendedProperties().getUnderlyingProperties().getApplication());
  }
View Full Code Here
TOP

Related Classes of org.apache.poi.POIXMLProperties

  • org.apache.poi.openxml4j.opc.PackagePartName
  • org.apache.poi.openxml4j.opc.PackageRelationshipCollection
  • org.apache.poi.xssf.extractor.XSSFEventBasedExcelExtractor
  • org.apache.poi.xssf.usermodel.examples.WorkbookProperties
  • org.apache.poi.xssf.usermodel.TestXSSFBugs
  • org.apache.poi.xssf.usermodel.TestXSSFWorkbook
  • org.apache.poi.xwpf.TestXWPFDocument
  • org.apache.poi.xwpf.usermodel.TestXWPFDocument
  • org.apache.xmlbeans.XmlOptions
  • org.openxml4j.opc.PackageRelationshipCollection
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.