/// <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);
}
public void SetUp()
{
HSSFRequest req = new HSSFRequest();
mockListen = new MockHSSFListener();
listener = new EventWorkbookBuilder.SheetRecordCollectingListener(mockListen);
req.AddListenerForAllRecords(listener);
HSSFEventFactory factory = new HSSFEventFactory();
try
{
Stream is1 = HSSFTestDataSamples.OpenSampleFileStream("3dFormulas.xls");
POIFSFileSystem fs = new POIFSFileSystem(is1);
factory.ProcessWorkbookEvents(req, fs);
}
catch (IOException)
{
throw;
}
}
