public void TestSimpleExcel5() { foreach (String ver in new String[] { "5", "95" }) { OldExcelExtractor extractor = CreateExtractor("testEXCEL_" + ver + ".xls"); // Check we can call GetText without error String text = extractor.Text; // Check we find a few words we expect in there AssertContains(text, "Sample Excel"); AssertContains(text, "Written and saved"); // Check we find a few numbers we expect in there AssertContains(text, "15"); AssertContains(text, "169"); // Check we got the sheet names (new formats only) AssertContains(text, "Sheet: Feuil3"); // Check the type Assert.AreEqual(5, extractor.BiffVersion); Assert.AreEqual(0x05, extractor.FileType); } }
public void TestFormattedNumbersExcel5() { foreach (String ver in new String[] { "5", "95" }) { OldExcelExtractor extractor = CreateExtractor("testEXCEL_" + ver + ".xls"); String text = extractor.Text; // Simple numbers AssertContains(text, "1"); // Numbers which come from formulas AssertContains(text, "13"); AssertContains(text, "169"); // Formatted numbers // TODO // AssertContains(text, "100.00%"); // AssertContains(text, "155.00%"); // AssertContains(text, "1,125"); // AssertContains(text, "189,945"); // AssertContains(text, "1,234,500"); // AssertContains(text, "$169.00"); // AssertContains(text, "$1,253.82"); } }
public void TestFromFile() { foreach (String ver in new String[] { "4", "5", "95" }) { String filename = "testEXCEL_" + ver + ".xls"; FileInfo f = HSSFTestDataSamples.GetSampleFile(filename); OldExcelExtractor extractor = new OldExcelExtractor(f); String text = extractor.Text; Assert.IsNotNull(text); Assert.IsTrue(text.Length > 100); } }
public static void main(String[] args) { if (args.Length < 1) { System.Console.WriteLine("Use:"); System.Console.WriteLine(" OldExcelExtractor <filename>"); return; } OldExcelExtractor extractor = new OldExcelExtractor(new FileInfo(args[0])); System.Console.WriteLine(extractor.Text); extractor.Close(); }
public void TestFormattedNumbersExcel4() { OldExcelExtractor extractor = CreateExtractor("testEXCEL_4.xls"); String text = extractor.Text; // Simple numbers AssertContains(text, "151"); AssertContains(text, "784"); // Numbers which come from formulas AssertContains(text, "0.398"); // TODO Rounding AssertContains(text, "624"); // Formatted numbers // TODO // AssertContains(text, "55,624"); // AssertContains(text, "11,743,477"); }
public void TestStrings() { OldExcelExtractor extractor = CreateExtractor("testEXCEL_4.xls"); String text = extractor.Text; // Simple strings AssertContains(text, "Table 10 -- Examination Coverage:"); AssertContains(text, "Recommended and Average Recommended Additional Tax After"); AssertContains(text, "Individual income tax returns, total"); // More complicated strings AssertContains(text, "$100,000 or more"); AssertContains(text, "S corporation returns, Form 1120S [10,15]"); AssertContains(text, "individual income tax return \u201Cshort forms.\u201D"); // Formula based strings // TODO Find some then test }
public void TestSimpleExcel4() { OldExcelExtractor extractor = CreateExtractor("testEXCEL_4.xls"); // Check we can call GetText without error String text = extractor.Text; // Check we find a few words we expect in there AssertContains(text, "Size"); AssertContains(text, "Returns"); // Check we find a few numbers we expect in there AssertContains(text, "11"); AssertContains(text, "784"); // Check the type Assert.AreEqual(4, extractor.BiffVersion); Assert.AreEqual(0x10, extractor.FileType); }
public void TestSimpleExcel3() { OldExcelExtractor extractor = CreateExtractor("testEXCEL_3.xls"); // Check we can call GetText without error String text = extractor.Text; // Check we find a few words we expect in there AssertContains(text, "Season beginning August"); AssertContains(text, "USDA"); // Check we find a few numbers we expect in there AssertContains(text, "347"); AssertContains(text, "228"); // Check we find a few string-literal dates in there AssertContains(text, "1981/82"); // Check the type Assert.AreEqual(3, extractor.BiffVersion); Assert.AreEqual(0x10, extractor.FileType); }