Examples of ExcelExtractor

Examples of org.apache.poi.hssf.extractor.ExcelExtractor

98
99
100
101
102
103
104
105
106
107
108
      fs = new POIFSFileSystem(_samples.openResourceAsStream("TestUnicode.xls"));
      wb = new HSSFWorkbook(fs);
    } catch (IOException e) {
      throw new RuntimeException(e);
    }
    ExcelExtractor excelExt = new ExcelExtractor(wb);

    String fsText = (new HPSFPropertiesExtractor(fs)).getText();
    String hwText = (new HPSFPropertiesExtractor(wb)).getText();
    String eeText = (new HPSFPropertiesExtractor(excelExt)).getText();
View Full Code Here

Examples of org.apache.poi.hssf.extractor.ExcelExtractor

147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
   */
  public void testComparedToOLE2() throws Exception {
    // A fairly simple file - ooxml
     XSSFEventBasedExcelExtractor ooxmlExtractor = getExtractor("SampleSS.xlsx");

    ExcelExtractor ole2Extractor =
      new ExcelExtractor(HSSFTestDataSamples.openSampleWorkbook("SampleSS.xls"));
   
    POITextExtractor[] extractors =
      new POITextExtractor[] { ooxmlExtractor, ole2Extractor };
    for (int i = 0; i < extractors.length; i++) {
      POITextExtractor extractor = extractors[i];
     
      String text = extractor.getText().replaceAll("[\r\t]", "");
      assertTrue(text.startsWith("First Sheet\nTest spreadsheet\n2nd row2nd row 2nd column\n"));
      Pattern pattern = Pattern.compile(".*13(\\.0+)?\\s+Sheet3.*", Pattern.DOTALL);
      Matcher m = pattern.matcher(text);
      assertTrue(m.matches());     
    }
   
    ole2Extractor.close();
    ooxmlExtractor.close();
  }
View Full Code Here

Examples of org.apache.poi.hssf.extractor.ExcelExtractor

214
215
216
217
218
219
220
221
222
223
224
        // out from
        if (poifsDir.hasEntry("Workbook")) {
            if (getPreferEventExtractor()) {
                return new EventBasedExcelExtractor(poifsDir);
            }
            return new ExcelExtractor(poifsDir);
        }

        if (poifsDir.hasEntry("WordDocument")) {
            // Old or new style word document?
            try {
View Full Code Here

Examples of org.apache.poi.hssf.extractor.ExcelExtractor

116
117
118
119
120
121
122
123
124
125
126
    //  out from
    for(Iterator entries = poifsDir.getEntries(); entries.hasNext(); ) {
      Entry entry = (Entry)entries.next();
     
      if(entry.getName().equals("Workbook")) {
        return new ExcelExtractor(poifsDir, fs);
      }
      if(entry.getName().equals("WordDocument")) {
        return new WordExtractor(poifsDir, fs);
      }
      if(entry.getName().equals("PowerPoint Document")) {
View Full Code Here

Examples of org.apache.poi.hssf.extractor.ExcelExtractor

121
122
123
124
125
126
127
128
129
130
131
132
   */
  public void testComparedToOLE2() {
    // A fairly simple file - ooxml
    XSSFExcelExtractor ooxmlExtractor = getExtractor("SampleSS.xlsx");

    ExcelExtractor ole2Extractor =
      new ExcelExtractor(HSSFTestDataSamples.openSampleWorkbook("SampleSS.xls"));
   
    POITextExtractor[] extractors =
      new POITextExtractor[] { ooxmlExtractor, ole2Extractor };
    for (int i = 0; i < extractors.length; i++) {
      POITextExtractor extractor = extractors[i];
View Full Code Here

Examples of org.apache.poi.hssf.extractor.ExcelExtractor

125
126
127
128
129
130
131
132
133
134
135
    //  out from
    for(Iterator entries = poifsDir.getEntries(); entries.hasNext(); ) {
      Entry entry = (Entry)entries.next();
     
      if(entry.getName().equals("Workbook")) {
        return new ExcelExtractor(poifsDir, fs);
      }
      if(entry.getName().equals("WordDocument")) {
        return new WordExtractor(poifsDir, fs);
      }
      if(entry.getName().equals("PowerPoint Document")) {
View Full Code Here

Examples of org.apache.poi.hssf.extractor.ExcelExtractor

105
106
107
108
109
110
111
112
113
114
115
            );
      wb = new HSSFWorkbook(fs);
    } catch (IOException e) {
      throw new RuntimeException(e);
    }
    ExcelExtractor excelExt = new ExcelExtractor(wb);

    String fsText = (new HPSFPropertiesExtractor(fs)).getText();
    String hwText = (new HPSFPropertiesExtractor(wb)).getText();
    String eeText = (new HPSFPropertiesExtractor(excelExt)).getText();
View Full Code Here

Examples of org.apache.poi.hssf.extractor.ExcelExtractor

212
213
214
215
216
217
218
219
220
221
222
     
      if(entry.getName().equals("Workbook")) {
         if(getPreferEventExtractor()) {
               return new EventBasedExcelExtractor(poifsDir, fs);
         } else {
            return new ExcelExtractor(poifsDir, fs);
         }
      }
      if(entry.getName().equals("WordDocument")) {
        return new WordExtractor(poifsDir, fs);
      }
View Full Code Here

Examples of org.apache.poi.hssf.extractor.ExcelExtractor

63
64
65
66
67
68
69
70
71
72
73
    public Reader extractText(InputStream stream,
                              String type,
                              String encoding) throws IOException {
        try {
            POIFSFileSystem fs = new POIFSFileSystem(stream);
            return new StringReader(new ExcelExtractor(fs).getText());
        } catch (RuntimeException e) {
            logger.warn("Failed to extract Excel text content", e);
            return new StringReader("");
        } finally {
            stream.close();
View Full Code Here

Examples of org.apache.poi.hssf.extractor.ExcelExtractor

126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
   */
  public void testComparedToOLE2() throws IOException {
    // A fairly simple file - ooxml
    XSSFExcelExtractor ooxmlExtractor = getExtractor("SampleSS.xlsx");

    ExcelExtractor ole2Extractor =
      new ExcelExtractor(HSSFTestDataSamples.openSampleWorkbook("SampleSS.xls"));
   
    POITextExtractor[] extractors =
      new POITextExtractor[] { ooxmlExtractor, ole2Extractor };
    for (int i = 0; i < extractors.length; i++) {
      POITextExtractor extractor = extractors[i];
     
      String text = extractor.getText().replaceAll("[\r\t]", "");
      assertTrue(text.startsWith("First Sheet\nTest spreadsheet\n2nd row2nd row 2nd column\n"));
      Pattern pattern = Pattern.compile(".*13(\\.0+)?\\s+Sheet3.*", Pattern.DOTALL);
      Matcher m = pattern.matcher(text);
      assertTrue(m.matches());     
    }

    ole2Extractor.close();
    ooxmlExtractor.close();
  }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.