Package org.apache.poi.hssf.eventusermodel

Examples of org.apache.poi.hssf.eventusermodel.HSSFEventFactory

128
129
130
131
132
133
134
135
136
137
138
139
140
    TextListener tl = new TextListener();
    FormatTrackingHSSFListener ft = new FormatTrackingHSSFListener(tl);
    tl._ft = ft;

    // Register and process
    HSSFEventFactory factory = new HSSFEventFactory();
    HSSFRequest request = new HSSFRequest();
    request.addListenerForAllRecords(ft);

    factory.processWorkbookEvents(request, _fs);

    return tl;
  }
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
    AbortableCountingListener l = new AbortableCountingListener(1000);
   
    HSSFRequest req = new HSSFRequest();
    req.addListenerForAllRecords(l);
   
    HSSFEventFactory f = new HSSFEventFactory();
   
    assertEquals(0, l.seen);
    assertEquals(null, l.lastseen);
   
    POIFSFileSystem fs = new POIFSFileSystem(new ByteArrayInputStream(
        getTestDataProvider().getTestDataFileContent("SimpleWithColours.xls")
    ));
    short res = f.abortableProcessWorkbookEvents(req, fs);
   
    assertEquals(0, res);
    assertEquals(175, l.seen);
    assertEquals(EOFRecord.sid, l.lastseen.getSid());
  }
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
    AbortableCountingListener l = new AbortableCountingListener(1);
   
    HSSFRequest req = new HSSFRequest();
    req.addListenerForAllRecords(l);
   
    HSSFEventFactory f = new HSSFEventFactory();
   
    assertEquals(0, l.seen);
    assertEquals(null, l.lastseen);
   
    POIFSFileSystem fs = new POIFSFileSystem(new ByteArrayInputStream(
        getTestDataProvider().getTestDataFileContent("SimpleWithColours.xls")
    ));
    short res = f.abortableProcessWorkbookEvents(req, fs);
   
    assertEquals(1234, res);
    assertEquals(1, l.seen);
    assertEquals(BOFRecord.sid, l.lastseen.getSid());
  }
View Full Code Here
142
143
144
145
146
147
148
149
150
151
            hssfRequest.addListener(listener, HyperlinkRecord.sid);
        }

        // Create event factory and process Workbook (fire events)
        DocumentInputStream documentInputStream = filesystem.createDocumentInputStream("Workbook");
        HSSFEventFactory eventFactory = new HSSFEventFactory();

        eventFactory.processEvents(hssfRequest, documentInputStream);
        listener.throwStoredException();
    }
View Full Code Here
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
   */
  public void process() throws IOException {
    MissingRecordAwareHSSFListener listener = new MissingRecordAwareHSSFListener(this);
    formatListener = new FormatTrackingHSSFListener(listener);
   
    HSSFEventFactory factory = new HSSFEventFactory();
    HSSFRequest request = new HSSFRequest();
   
    if(outputFormulaValues) {
      request.addListenerForAllRecords(formatListener);
    } else {
      workbookBuildingListener = new SheetRecordCollectingListener(formatListener);
      request.addListenerForAllRecords(workbookBuildingListener);
    }
   
    factory.processWorkbookEvents(request, fs);
  }
View Full Code Here
271
272
273
274
275
276
277
278
279
280
281
282
283
                hssfRequest.addListener(formatListener, DrawingGroupRecord.sid);
            }

            // Create event factory and process Workbook (fire events)
            DocumentInputStream documentInputStream = filesystem.createDocumentInputStream("Workbook");
            HSSFEventFactory eventFactory = new HSSFEventFactory();
            try {
                eventFactory.processEvents(hssfRequest, documentInputStream);
            } catch (org.apache.poi.EncryptedDocumentException e) {
                throw new EncryptedDocumentException(e);
            }
           
            // Output any extra text that came after all the sheets
View Full Code Here
142
143
144
145
146
147
148
149
150
151
            hssfRequest.addListener(listener, HyperlinkRecord.sid);
        }

        // Create event factory and process Workbook (fire events)
        DocumentInputStream documentInputStream = filesystem.createDocumentInputStream("Workbook");
        HSSFEventFactory eventFactory = new HSSFEventFactory();

        eventFactory.processEvents(hssfRequest, documentInputStream);
        listener.throwStoredException();
    }
View Full Code Here
148
149
150
151
152
153
154
155
156
157
158
159
160
    TextListener tl = new TextListener();
    FormatTrackingHSSFListener ft = new FormatTrackingHSSFListener(tl);
    tl._ft = ft;

    // Register and process
    HSSFEventFactory factory = new HSSFEventFactory();
    HSSFRequest request = new HSSFRequest();
    request.addListenerForAllRecords(ft);

    factory.processWorkbookEvents(request, _dir);

    return tl;
  }
View Full Code Here
56
57
58
59
60
61
62
63
64
            public void processRecord(Record rec)
            {
                System.out.println(rec.toString());
            }
        });
        HSSFEventFactory factory = new HSSFEventFactory();

        factory.processEvents(req, din);
    }
View Full Code Here
136
137
138
139
140
141
142
143
144
145
146
147
148
    TextListener tl = new TextListener();
    FormatTrackingHSSFListener ft = new FormatTrackingHSSFListener(tl);
    tl._ft = ft;

    // Register and process
    HSSFEventFactory factory = new HSSFEventFactory();
    HSSFRequest request = new HSSFRequest();
    request.addListenerForAllRecords(ft);

    factory.processWorkbookEvents(request, _dir);

    return tl;
  }
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.eventusermodel.HSSFEventFactory

  • com.common.platform.excel.parser.HSSFParser
  • com.sishuok.es.showcase.excel.service.ExcelDataService
  • evolaris.framework.sys.business.XLS2CSVmra
  • net.yacy.document.parser.xlsParser$XLSHSSFListener
  • org.apache.poi.hssf.dev.EFBiffViewer
  • org.apache.poi.hssf.dev.EFHSSF
  • org.apache.poi.hssf.eventmodel.TestAbortableListener
  • org.apache.poi.hssf.eventusermodel.examples.XLS2CSVmra
  • org.apache.poi.hssf.eventusermodel.TestHSSFEventFactory
  • org.apache.poi.hssf.eventusermodel.TestMissingRecordAwareHSSFListener
    • 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.