/// <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);
}
