Package org.apache.poi.xssf.eventusermodel

Examples of org.apache.poi.xssf.eventusermodel.XSSFReader$SheetIterator

49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
    sheet2.close();
  }

  public void processAllSheets(String filename) throws Exception {
    Package pkg = Package.open(filename);
    XSSFReader r = new XSSFReader( pkg );
    SharedStringsTable sst = r.getSharedStringsTable();
   
    XMLReader parser = fetchSheetParser(sst);

    Iterator<InputStream> sheets = r.getSheetsData();
    while(sheets.hasNext()) {
      System.out.println("Processing new sheet:\n");
      InputStream sheet = sheets.next();
      InputSource sheetSource = new InputSource(sheet);
      parser.parse(sheetSource);
View Full Code Here
325
326
327
328
329
330
331
332
333
334
335
336
337
    * Processes the file and returns the text
    */
   public String getText() {
       try {
          ReadOnlySharedStringsTable strings = new ReadOnlySharedStringsTable(container);
          XSSFReader xssfReader = new XSSFReader(container);
          StylesTable styles = xssfReader.getStylesTable();
          XSSFReader.SheetIterator iter = (XSSFReader.SheetIterator) xssfReader.getSheetsData();
  
          StringBuffer text = new StringBuffer();
          while (iter.hasNext()) {
              InputStream stream = iter.next();
              if(includeSheetNames) {
View Full Code Here
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
            List<ExcelData> dataList = Lists.newArrayList();

            bis = new BufferedInputStream(is);
            OPCPackage pkg = OPCPackage.open(bis);
            XSSFReader r = new XSSFReader(pkg);

            XMLReader parser =
                    XMLReaderFactory.createXMLReader();
            ContentHandler handler = new Excel2007ImportSheetHandler(proxy, dataList, batchSize);
            parser.setContentHandler(handler);

            Iterator<InputStream> sheets = r.getSheetsData();
            while (sheets.hasNext()) {
                InputStream sheet = null;
                try {
                    sheet = sheets.next();
                    InputSource sheetSource = new InputSource(sheet);
View Full Code Here
159
160
161
162
163
164
165
166
167
168
169
170
171
    * Processes the file and returns the text
    */
   public String getText() {
       try {
          ReadOnlySharedStringsTable strings = new ReadOnlySharedStringsTable(container);
          XSSFReader xssfReader = new XSSFReader(container);
          StylesTable styles = xssfReader.getStylesTable();
          XSSFReader.SheetIterator iter = (XSSFReader.SheetIterator) xssfReader.getSheetsData();
  
          StringBuffer text = new StringBuffer();
          SheetTextExtractor sheetExtractor = new SheetTextExtractor(text);
         
          while (iter.hasNext()) {
View Full Code Here
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
* XSSF and SAX (Event API)
*/
public class FromHowTo {
  public void processOneSheet(String filename) throws Exception {
    OPCPackage pkg = OPCPackage.open(filename);
    XSSFReader r = new XSSFReader( pkg );
    SharedStringsTable sst = r.getSharedStringsTable();

    XMLReader parser = fetchSheetParser(sst);

    // rId2 found by processing the Workbook
    // Seems to either be rId# or rSheet#
    InputStream sheet2 = r.getSheet("rId2");
    InputSource sheetSource = new InputSource(sheet2);
    parser.parse(sheetSource);
    sheet2.close();
  }
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
    sheet2.close();
  }

  public void processAllSheets(String filename) throws Exception {
    OPCPackage pkg = OPCPackage.open(filename);
    XSSFReader r = new XSSFReader( pkg );
    SharedStringsTable sst = r.getSharedStringsTable();
   
    XMLReader parser = fetchSheetParser(sst);

    Iterator<InputStream> sheets = r.getSheetsData();
    while(sheets.hasNext()) {
      System.out.println("Processing new sheet:\n");
      InputStream sheet = sheets.next();
      InputSource sheetSource = new InputSource(sheet);
      parser.parse(sheetSource);
View Full Code Here
66
67
68
69
70
71
72
73
74
75
    }

    @Override
    public DataSet executeQuery(InputStream inputStream, Table table, Column[] columns, int maxRows) throws Exception {
        final OPCPackage pkg = OPCPackage.open(inputStream);
        final XSSFReader xssfReader = new XSSFReader(pkg);
        final String relationshipId = _tableNamesToInternalIds.get(table.getName());

        return buildDataSet(columns, maxRows, relationshipId, xssfReader);
    }
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
    @Override
    public Schema createSchema(InputStream inputStream, String schemaName) throws Exception {
        final MutableSchema schema = new MutableSchema(schemaName);
        final OPCPackage pkg = OPCPackage.open(inputStream);
        final XSSFReader xssfReader = new XSSFReader(pkg);

        final XlsxWorkbookToTablesHandler workbookToTables = new XlsxWorkbookToTablesHandler(schema,
                _tableNamesToInternalIds);
        buildTables(xssfReader, workbookToTables);
View Full Code Here
101
102
103
104
105
106
107
108
109
110
111
        InputStream inputStream = inputStreamRef.get();
        final XlsxWorkbookToTablesHandler workbookToTables = new XlsxWorkbookToTablesHandler(null,
                _tableNamesToInternalIds);
        try {
            final OPCPackage pkg = OPCPackage.open(inputStream);
            final XSSFReader xssfReader = new XSSFReader(pkg);
            buildTables(xssfReader, workbookToTables);
        } catch (Exception e) {
            throw new IllegalStateException(e);
        } finally {
            FileHelper.safeClose(inputStream);
View Full Code Here
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
* XSSF and SAX (Event API)
*/
public class FromHowTo {
  public void processOneSheet(String filename) throws Exception {
    OPCPackage pkg = OPCPackage.open(filename);
    XSSFReader r = new XSSFReader( pkg );
    SharedStringsTable sst = r.getSharedStringsTable();

    XMLReader parser = fetchSheetParser(sst);

    // rId2 found by processing the Workbook
    // Seems to either be rId# or rSheet#
    InputStream sheet2 = r.getSheet("rId2");
    InputSource sheetSource = new InputSource(sheet2);
    parser.parse(sheetSource);
    sheet2.close();
  }
View Full Code Here
TOP

Related Classes of org.apache.poi.xssf.eventusermodel.XSSFReader$SheetIterator

  • com.common.platform.excel.parser.XSSFParser
  • com.gentics.cr.lucene.indexer.transformer.xlsx.XLSXContentTransformer
  • com.sishuok.es.showcase.excel.service.ExcelDataService
  • org.apache.metamodel.excel.XlsxSpreadsheetReaderDelegate
  • org.apache.poi.openxml4j.opc.PackagePart
  • org.apache.poi.openxml4j.opc.PackagePartName
  • org.apache.poi.openxml4j.opc.PackageRelationship
  • org.apache.poi.openxml4j.opc.PackageRelationshipCollection
  • org.apache.poi.xssf.eventusermodel.examples.FromHowTo
  • org.apache.poi.xssf.eventusermodel.XLSX2CSV
    • 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.