public void TestMain()
{
FileInfo file = HSSFTestDataSamples.GetSampleFile("testEXCEL_3.xls");
TextWriter save = Console.Out;
try
{
ByteArrayOutputStream out1 = new ByteArrayOutputStream();
try
{
TextWriter str = new StreamWriter(out1, Encoding.UTF8)
{
AutoFlush = false
};
Console.SetOut(str);
OldExcelExtractor.main(new String[] { file.FullName });
}
finally
{
out1.Close();
}
String string1 = Encoding.UTF8.GetString(out1.ToByteArray());
Assert.IsTrue(string1.Contains("Table C-13--Lemons"), "Had: " + string1);
}
finally
{
Console.SetOut(save);
}
}
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);
extractor.Close();
}
}
public void TestMainUsage()
{
TextWriter save = System.Console.Error;
try
{
ByteArrayOutputStream out1 = new ByteArrayOutputStream();
try
{
TextWriter str = new StreamWriter(out1, Encoding.UTF8)
{
AutoFlush = false
};
Console.SetError(str);
OldExcelExtractor.main(new String[] { });
}
finally
{
out1.Close();
}
}
finally
{
Console.SetError(save);
}
}
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");
extractor.Close();
}
}
public void TestSimpleExcel3NoReading()
{
OldExcelExtractor extractor = CreateExtractor("testEXCEL_3.xls");
Assert.IsNotNull(extractor);
extractor.Close();
}
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 void TestOpenNonExistingFile()
{
// a file that exists, but is a different format
try
{
OldExcelExtractor extractor = new OldExcelExtractor(new FileInfo("notexistingfile.xls"));
extractor.Close();
Assert.Fail("Should catch Exception here");
}
catch (FileNotFoundException)
{
// expected here
}
}
public void TestDirectoryNode()
{
FileInfo file = HSSFTestDataSamples.GetSampleFile("FormulaRefs.xls");
NPOIFSFileSystem fs = new NPOIFSFileSystem(file);
try
{
OldExcelExtractor extractor = new OldExcelExtractor(fs.Root);
extractor.Close();
}
finally
{
fs.Close();
}
}
public void TestInputStreamNPOIHeader()
{
FileInfo file = HSSFTestDataSamples.GetSampleFile("FormulaRefs.xls");
Stream stream = file.OpenRead();
try
{
OldExcelExtractor extractor = new OldExcelExtractor(stream);
extractor.Close();
}
finally
{
stream.Close();
}
}
public void TestInputStream()
{
FileInfo file = HSSFTestDataSamples.GetSampleFile("testEXCEL_3.xls");
Stream stream = file.OpenRead();
try
{
OldExcelExtractor extractor = new OldExcelExtractor(stream);
String text = extractor.Text;
Assert.IsNotNull(text);
extractor.Close();
}
finally
{
stream.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 TestDirectoryNodeInvalidFile()
{
FileStream file = POIDataSamples.GetDocumentInstance().GetFile("test.doc");
NPOIFSFileSystem fs = new NPOIFSFileSystem(file);
try
{
OldExcelExtractor extractor = new OldExcelExtractor(fs.Root);
extractor.Close();
Assert.Fail("Should catch exception here");
}
catch (FileNotFoundException)
{
// expected here
}
finally
{
fs.Close();
}
}
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);
}
