public void TestWithCrazyContinueRecords() { // Some files have crazy ordering of their continue records // Check that we don't break on them (bug #42844) HSSFRequest req = new HSSFRequest(); MockHSSFListener mockListen = new MockHSSFListener(); req.AddListenerForAllRecords(mockListen); POIFSFileSystem fs = new POIFSFileSystem(OpenSample("ContinueRecordProblem.xls")); HSSFEventFactory factory = new HSSFEventFactory(); factory.ProcessWorkbookEvents(req, fs); Record[] recs = mockListen.GetRecords(); // Check we got the records Assert.IsTrue(recs.Length > 100); // And none of them are continue ones for (int i = 0; i < recs.Length; i++) { Assert.IsFalse(recs[i] is ContinueRecord); } // Check that the last few records are as we expect // (Makes sure we don't accidently skip the end ones) int numRec = recs.Length; Assert.AreEqual(typeof(DVALRecord), recs[numRec - 3].GetType()); Assert.AreEqual(typeof(DVRecord), recs[numRec - 2].GetType()); Assert.AreEqual(typeof(EOFRecord), recs[numRec - 1].GetType()); }
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; } }
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; } }
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); }
public void TestWithMissingRecords() { HSSFRequest req = new HSSFRequest(); MockHSSFListener mockListen = new MockHSSFListener(); req.AddListenerForAllRecords(mockListen); POIFSFileSystem fs = new POIFSFileSystem(OpenSample("SimpleWithSkip.xls")); HSSFEventFactory factory = new HSSFEventFactory(); factory.ProcessWorkbookEvents(req, fs); Record[] recs = mockListen.GetRecords(); // Check we got the records Assert.IsTrue(recs.Length > 100); // Check that the last few records are as we expect // (Makes sure we don't accidently skip the end ones) int numRec = recs.Length; Assert.AreEqual(typeof(WindowTwoRecord), recs[numRec - 3].GetType()); Assert.AreEqual(typeof(SelectionRecord), recs[numRec - 2].GetType()); Assert.AreEqual(typeof(EOFRecord), recs[numRec - 1].GetType()); }
/// <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; }
public void TestUnknownContinueRecords() { HSSFRequest req = new HSSFRequest(); MockHSSFListener mockListen = new MockHSSFListener(); req.AddListenerForAllRecords(mockListen); POIFSFileSystem fs = new POIFSFileSystem(OpenSample("42844.xls")); HSSFEventFactory factory = new HSSFEventFactory(); factory.ProcessWorkbookEvents(req, fs); Assert.IsTrue(true, "no errors while Processing the file"); }