Package org.apache.poi.xssf.eventusermodel

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

572
573
574
575
576
577
578
579
580
581
582
583
584
     */
    public void process()
            throws IOException, OpenXML4JException, ParserConfigurationException, SAXException {

        ReadonlySharedStringsTable strings = new ReadonlySharedStringsTable(this.xlsxPackage);
        XSSFReader xssfReader = new XSSFReader(this.xlsxPackage);
        StylesTable styles = xssfReader.getStylesTable();
        XSSFReader.SheetIterator iter = (XSSFReader.SheetIterator) xssfReader.getSheetsData();
        int index = 0;
        while (iter.hasNext()) {
            InputStream stream = iter.next();
            String sheetName = iter.getSheetName();
            this.output.println();
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
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
      throw new IllegalArgumentException("Parameter must be instance of byte[]");
    }
    try {
      Package pkg = Package.open(is);

      XSSFReader r = new XSSFReader(pkg);
      SharedStringsTable sst = r.getSharedStringsTable();
      SheetHandler handler = new SheetHandler(sst);

      XMLReader parser = fetchSheetParser(handler);

      Iterator<InputStream> sheets = r.getSheetsData();
      while (sheets.hasNext()) {
        InputStream sheet = sheets.next();
        InputSource sheetSource = new InputSource(sheet);
        parser.parse(sheetSource);
        sheet.close();
View Full Code Here
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
            XmlException, IOException {
       OPCPackage container = extractor.getPackage();
      
       ReadOnlySharedStringsTable strings;
       XSSFReader.SheetIterator iter;
       XSSFReader xssfReader;
       StylesTable styles;
       try {
          xssfReader = new XSSFReader(container);
          styles = xssfReader.getStylesTable();
          iter = (XSSFReader.SheetIterator) xssfReader.getSheetsData();
          strings = new ReadOnlySharedStringsTable(container);
       } catch(InvalidFormatException e) {
          throw new XmlException(e);
       } catch (OpenXML4JException oe) {
          throw new XmlException(oe);
View Full Code Here
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
     * @see com.common.platform.excel.parser.ExcelDataParser#parser(java.lang.String)
     */
    @Override
    public void parser(String fileName) throws Throwable {
        OPCPackage pkg = OPCPackage.open(fileName);
        XSSFReader r = new XSSFReader(pkg);
        this.sharedTable = r.getSharedStringsTable();
        this.stylesTable = r.getStylesTable();

        XMLReader parser = XMLReaderFactory.createXMLReader("org.apache.xerces.parsers.SAXParser");
        parser.setContentHandler(this);

        Iterator<InputStream> sheets = r.getSheetsData();
        while (sheets.hasNext()) {
            currentRow = 0;
            sheetIndex++;
            InputStream sheet = sheets.next();
            InputSource sheetSource = new InputSource(sheet);
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
    }

    @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());
       
        if (relationshipId == null) {
            throw new IllegalStateException("No internal relationshipId found for table: " + table);
        }
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
    @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
103
104
105
106
107
108
109
110
111
112
113
        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
191
192
193
194
195
196
197
198
199
200
201
202
203
    * 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();
         
          while (iter.hasNext()) {
View Full Code Here
TOP

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

  • 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.