/// <summary> /// Initiates the processing of the XLS file to strings /// </summary> public void Process() { var listener = new MissingRecordAwareHSSFListener(this); _formatListener = new FormatTrackingHSSFListener(listener); var factory = new HSSFEventFactory(); var request = new HSSFRequest(); _workbookBuildingListener = new EventWorkbookBuilder.SheetRecordCollectingListener(_formatListener); request.AddListenerForAllRecords(_workbookBuildingListener); factory.ProcessWorkbookEvents(request, _fs); }
private void ReadRecords(String sampleFileName) { HSSFRequest req = new HSSFRequest(); MockHSSFListener mockListen = new MockHSSFListener(); MissingRecordAwareHSSFListener listener = new MissingRecordAwareHSSFListener(mockListen); req.AddListenerForAllRecords(listener); HSSFEventFactory factory = new HSSFEventFactory(); try { Stream is1 = HSSFTestDataSamples.OpenSampleFileStream(sampleFileName); POIFSFileSystem fs = new POIFSFileSystem(is1); factory.ProcessWorkbookEvents(req, fs); } catch (IOException) { throw; } r = mockListen.GetRecords(); Assert.IsTrue(r.Length > 100); }