Package org.apache.poi.hssf.eventusermodel

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

70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
    AbortableCountingListener l = new AbortableCountingListener(1);

    HSSFRequest req = new HSSFRequest();
    req.addListenerForAllRecords(l);

    HSSFEventFactory f = new HSSFEventFactory();

    assertEquals(0, l.countSeen);
    assertEquals(null, l.lastRecordSeen);

    POIFSFileSystem fs = openSample();
    short res = f.abortableProcessWorkbookEvents(req, fs);

    assertEquals(1234, res);
    assertEquals(1, l.countSeen);
    assertEquals(BOFRecord.sid, l.lastRecordSeen.getSid());
  }
View Full Code Here
50
51
52
53
54
55
56
57
58
            public void processRecord(Record rec)
            {
                System.out.println(rec.toString());
            }
        });
        HSSFEventFactory factory = new HSSFEventFactory();

        factory.processEvents(req, din);
    }
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
69
      ChartTitleFormatRecordGrabber grabber =
        new ChartTitleFormatRecordGrabber();
      InputStream din = fs.createDocumentInputStream("Workbook");
        HSSFRequest req = new HSSFRequest();
        req.addListenerForAllRecords(grabber);
        HSSFEventFactory factory = new HSSFEventFactory();
        factory.processEvents(req, din);
        din.close();
       
        // Should've found one
        assertEquals(1, grabber.chartTitleFormatRecords.size());
        // And it should be of something interesting
View Full Code Here
48
49
50
51
52
53
54
55
56
57
58
59
    MockHSSFListener mockListen = new MockHSSFListener();
    MissingRecordAwareHSSFListener listener = new MissingRecordAwareHSSFListener(mockListen);
    req.addListenerForAllRecords(listener);
   
    POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(f));
    HSSFEventFactory factory = new HSSFEventFactory();
    factory.processWorkbookEvents(req, fs);
   
    // Check we got the dummy records
    Record[] r = (Record[])
      mockListen.records.toArray(new Record[mockListen.records.size()]);
   
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
122
    MockHSSFListener mockListen = new MockHSSFListener();
    MissingRecordAwareHSSFListener listener = new MissingRecordAwareHSSFListener(mockListen);
    req.addListenerForAllRecords(listener);
   
    POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(f));
    HSSFEventFactory factory = new HSSFEventFactory();
    factory.processWorkbookEvents(req, fs);
   
    // Check we got the dummy records
    Record[] r = (Record[])
      mockListen.records.toArray(new Record[mockListen.records.size()]);
   
View Full Code Here
246
247
248
249
250
251
252
253
254
255
256
257
    MockHSSFListener mockListen = new MockHSSFListener();
    MissingRecordAwareHSSFListener listener = new MissingRecordAwareHSSFListener(mockListen);
    req.addListenerForAllRecords(listener);
   
    POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(f));
    HSSFEventFactory factory = new HSSFEventFactory();
    factory.processWorkbookEvents(req, fs);
   
    // Check we got the dummy records
    Record[] r = (Record[])
      mockListen.records.toArray(new Record[mockListen.records.size()]);
   
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
    HSSFRequest req = new HSSFRequest();
    MockHSSFListener mockListen = new MockHSSFListener();
    req.addListenerForAllRecords(mockListen);
   
    POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(f));
    HSSFEventFactory factory = new HSSFEventFactory();
    factory.processWorkbookEvents(req, fs);

    // Check we got the records
    assertTrue( mockListen.records.size() > 100 );
  }
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
71
    HSSFRequest req = new HSSFRequest();
    MockHSSFListener mockListen = new MockHSSFListener();
    req.addListenerForAllRecords(mockListen);
   
    POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(f));
    HSSFEventFactory factory = new HSSFEventFactory();
    factory.processWorkbookEvents(req, fs);

    // Check we got the records
    assertTrue( mockListen.records.size() > 100 );

    // And none of them are continue ones
View Full Code Here
87
88
89
90
91
92
93
94
95
96
        HSSFRequest req = new HSSFRequest();
        MockHSSFListener mockListen = new MockHSSFListener();
        req.addListenerForAllRecords(mockListen);

        POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(f));
        HSSFEventFactory factory = new HSSFEventFactory();
        factory.processWorkbookEvents(req, fs);

        assertTrue("no errors while processing the file", true);
    }
View Full Code Here
102
103
104
105
106
107
108
109
110
111
112
  /**
   * Initiates the processing of the XLS file to CSV
   */
  public void process() throws IOException {
    MissingRecordAwareHSSFListener listener = new MissingRecordAwareHSSFListener(this);
    HSSFEventFactory factory = new HSSFEventFactory();
    HSSFRequest request = new HSSFRequest();
    request.addListenerForAllRecords(listener);
   
    factory.processWorkbookEvents(request, fs);
  }
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.