public void parseFileTest()
{
DataReaderExcel target = new DataReaderExcel();
target.setFilePath(this.testDataSource);
bool expected = true;
bool actual;
actual = target.parseFile("Sheet1");
// Check that it parsed correctly
Assert.AreEqual <bool>(expected, actual);
// Check parsed
DataTable results = target.getDataSet();
Assert.IsNotNull(results);
// Check column names
Assert.AreEqual <String>(results.Columns[0].ColumnName, "FIRST_NAME");
Assert.AreEqual <String>(results.Columns[1].ColumnName, "LAST_NAME");
// Check strings
Assert.AreEqual <String>((String)results.Rows[0][0], "Reed");
Assert.AreEqual <String>((String)results.Rows[0][1], "Richards");
Assert.AreEqual <String>((String)results.Rows[7][0], "Thor");
// Check Empty String
Assert.AreEqual <String>((String)results.Rows[7][1], "");
}
public void formatDataTest()
{
// Parse Test Document
DataReaderExcel target = new DataReaderExcel();
target.setFilePath(this.testDataSource);
target.parseFile("Sheet1");
DataTable results = target.getDataSet();
// Check date format
Object obj = results.Rows[4][10];
DateTime date = new DateTime(2012, 5, 29);
Assert.AreEqual <String>((String)results.Rows[4][10], date.ToShortDateString());
date = new DateTime(2012, 7, 4);
Assert.AreEqual <String>((String)results.Rows[4][10], date.ToShortDateString());
}