/// <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); }
/// <summary> /// Triggers the extraction. /// </summary> /// <returns></returns> private TextListener TriggerExtraction() { TextListener tl = new TextListener(includeSheetNames, formulasNotResults); 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); }
private void ProcessFile(string filename) { HSSFRequest req = new HSSFRequest(); mockListen = new MockHSSFListener(); listener = new FormatTrackingHSSFListener(mockListen); req.AddListenerForAllRecords(listener); HSSFEventFactory factory = new HSSFEventFactory(); try { Stream is1 = HSSFTestDataSamples.OpenSampleFileStream(filename); POIFSFileSystem fs = new POIFSFileSystem(is1); factory.ProcessWorkbookEvents(req, fs); } catch (IOException) { throw; } }