Package org.apache.poi.xssf.extractor

Examples of org.apache.poi.xssf.extractor.XSSFExcelExtractor

36
37
38
39
40
41
42
43
44
45
46
47
    OPCPackage pkg = OPCPackage.open(
        (new File(dirname, "ExcelWithAttachments.xlsx")).toString()
    );
    XSSFWorkbook wb = new XSSFWorkbook(pkg);

    XSSFExcelExtractor ext = new XSSFExcelExtractor(wb);
    POIXMLPropertiesTextExtractor textExt = ext.getMetadataTextExtractor();
   
    // Check basics
    assertNotNull(textExt);
    assertTrue(textExt.getText().length() > 0);
   
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
      throw new IllegalArgumentException("Invalid OOXML Package received - expected 1 core document, found " + core.size());
    }
   
    PackagePart corePart = pkg.getPart(core.getRelationship(0));
    if(corePart.getContentType().equals(XSSFRelation.WORKBOOK.getContentType())) {
      return new XSSFExcelExtractor(pkg);
    }
    if(corePart.getContentType().equals(XWPFRelation.DOCUMENT.getContentType())) {
      return new XWPFWordExtractor(pkg);
    }
    if(corePart.getContentType().equals(XSLFSlideShow.MAIN_CONTENT_TYPE)) {
View Full Code Here
99
100
101
102
103
104
105
106
107
108
109
        if (corePart.getContentType().equals(XSSFRelation.WORKBOOK.getContentType()) ||
            corePart.getContentType().equals(XSSFRelation.MACRO_TEMPLATE_WORKBOOK.getContentType()) ||
            corePart.getContentType().equals(XSSFRelation.MACRO_ADDIN_WORKBOOK.getContentType()) ||
            corePart.getContentType().equals(XSSFRelation.TEMPLATE_WORKBOOK.getContentType()) ||
            corePart.getContentType().equals(XSSFRelation.MACROS_WORKBOOK.getContentType())) {
            return new XSSFExcelExtractor(pkg);
        }

        if(corePart.getContentType().equals(XWPFRelation.DOCUMENT.getContentType()) ||
            corePart.getContentType().equals(XWPFRelation.TEMPLATE.getContentType()) ||
            corePart.getContentType().equals(XWPFRelation.MACRO_DOCUMENT.getContentType()) ||
View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
  public void testGetFromMainExtractor() throws Exception {
    OPCPackage pkg = PackageHelper.open(_ssSamples.openResourceAsStream("ExcelWithAttachments.xlsm"));

    XSSFWorkbook wb = new XSSFWorkbook(pkg);

    XSSFExcelExtractor ext = new XSSFExcelExtractor(wb);
    POIXMLPropertiesTextExtractor textExt = ext.getMetadataTextExtractor();

    // Check basics
    assertNotNull(textExt);
    assertTrue(textExt.getText().length() > 0);

    // Check some of the content
    String text = textExt.getText();
    String cText = textExt.getCorePropertiesText();

    assertTrue(text.contains("LastModifiedBy = Yury Batrakov"));
    assertTrue(cText.contains("LastModifiedBy = Yury Batrakov"));
   
    textExt.close();
    ext.close();
  }
View Full Code Here
169
170
171
172
173
174
175
176
177
178
179
          if(corePart.getContentType().equals(rel.getContentType())) {
             if(getPreferEventExtractor()) {
                return new XSSFEventBasedExcelExtractor(pkg);
             }

             return new XSSFExcelExtractor(pkg);
          }
       }

       // Is it XWPF?
       for(XWPFRelation rel : XWPFWordExtractor.SUPPORTED_TYPES) {
View Full Code Here
36
37
38
39
40
41
42
43
44
45
46
47
    org.apache.poi.openxml4j.opc.Package pkg = Package.open(
        (new File(dirname, "ExcelWithAttachments.xlsx")).toString()
    );
    XSSFWorkbook wb = new XSSFWorkbook(pkg);

    XSSFExcelExtractor ext = new XSSFExcelExtractor(wb);
    POIXMLPropertiesTextExtractor textExt = ext.getMetadataTextExtractor();
   
    // Check basics
    assertNotNull(textExt);
    assertTrue(textExt.getText().length() > 0);
   
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
      throw new IllegalArgumentException("Invalid OOXML Package received - expected 1 core document, found " + core.size());
    }
   
    PackagePart corePart = pkg.getPart(core.getRelationship(0));
    if(corePart.getContentType().equals(XSSFRelation.WORKBOOK.getContentType())) {
      return new XSSFExcelExtractor(pkg);
    }
    if(corePart.getContentType().equals(XWPFRelation.DOCUMENT.getContentType())) {
      return new XWPFWordExtractor(pkg);
    }
    if(corePart.getContentType().equals(XSLFSlideShow.MAIN_CONTENT_TYPE)) {
View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
42
  public void testGetFromMainExtractor() throws Exception {
    OPCPackage pkg = PackageHelper.open(_ssSamples.openResourceAsStream("ExcelWithAttachments.xlsm"));

    XSSFWorkbook wb = new XSSFWorkbook(pkg);

    XSSFExcelExtractor ext = new XSSFExcelExtractor(wb);
    POIXMLPropertiesTextExtractor textExt = ext.getMetadataTextExtractor();

    // Check basics
    assertNotNull(textExt);
    assertTrue(textExt.getText().length() > 0);
View Full Code Here
99
100
101
102
103
104
105
106
107
108
109
        if (corePart.getContentType().equals(XSSFRelation.WORKBOOK.getContentType()) ||
            corePart.getContentType().equals(XSSFRelation.MACRO_TEMPLATE_WORKBOOK.getContentType()) ||
            corePart.getContentType().equals(XSSFRelation.MACRO_ADDIN_WORKBOOK.getContentType()) ||
            corePart.getContentType().equals(XSSFRelation.TEMPLATE_WORKBOOK.getContentType()) ||
            corePart.getContentType().equals(XSSFRelation.MACROS_WORKBOOK.getContentType())) {
            return new XSSFExcelExtractor(pkg);
        }

        if(corePart.getContentType().equals(XWPFRelation.DOCUMENT.getContentType()) ||
            corePart.getContentType().equals(XWPFRelation.TEMPLATE.getContentType()) ||
            corePart.getContentType().equals(XWPFRelation.MACRO_DOCUMENT.getContentType()) ||
View Full Code Here
166
167
168
169
170
171
172
173
174
175
176
            corePart.getContentType().equals(XSSFRelation.TEMPLATE_WORKBOOK.getContentType()) ||
            corePart.getContentType().equals(XSSFRelation.MACROS_WORKBOOK.getContentType())) {
           if(getPreferEventExtractor()) {
              return new XSSFEventBasedExcelExtractor(pkg);
           } else {
              return new XSSFExcelExtractor(pkg);
           }
        }

        if(corePart.getContentType().equals(XWPFRelation.DOCUMENT.getContentType()) ||
            corePart.getContentType().equals(XWPFRelation.TEMPLATE.getContentType()) ||
View Full Code Here
TOP

Related Classes of org.apache.poi.xssf.extractor.XSSFExcelExtractor

  • org.apache.poi.extractor.ExtractorFactory
  • org.apache.poi.POIXMLTextExtractor
  • org.apache.poi.ss.usermodel.Cell
  • org.apache.poi.ss.usermodel.CellStyle
  • org.apache.poi.ss.usermodel.Comment
  • org.apache.poi.ss.usermodel.DataFormatter
  • org.apache.poi.ss.usermodel.Row
  • org.apache.poi.ss.usermodel.Sheet
  • org.apache.poi.TestXMLPropertiesTextExtractor
  • org.apache.poi.xssf.usermodel.XSSFCell
    • 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.