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()); }