Package org.apache.poi.xssf.eventusermodel

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

168
169
170
171
172
173
174
175
176
177
178
179
180
    * 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
171
172
173
174
175
176
177
178
179
180
181
182
183
    * 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
188
189
190
191
192
193
194
195
196
197
198
199
200
    * 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
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 {
    Package pkg = Package.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 {
    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
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
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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
* Various things from the how-to documentation
*/
public class FromHowTo {
  public void processOneSheet(String filename) throws Exception {
    Package pkg = Package.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

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