public void Test_ExcelReader_GetsDataset()
{
ExcelReader.IDataSetReader E = new ExcelReader.ExcelToDataSetReader();
var file = ExcelReaderTest.Properties.Resources.TestWorkbook1;
DataSet ds = E.GetDataSet(file);
Assert.IsNotNull(ds);
}
public void Test_ExcelReader_GetsDatatable_ColumnCount()
{
ExcelReader.IDataSetReader E = new ExcelReader.ExcelToDataSetReader();
var file = ExcelReaderTest.Properties.Resources.TestWorkbook1;
DataSet ds = E.GetDataSet(file);
DataTable dt = ds.Tables[Sheet];
Int32 expectedColumnCount = 5;
Assert.AreEqual<Int32>(expectedColumnCount, dt.Columns.Count);
}
public void Test_ExcelReader_GetsDatatable()
{
ExcelReader.IDataSetReader E = new ExcelReader.ExcelToDataSetReader();
var file = ExcelReaderTest.Properties.Resources.TestWorkbook1;
DataSet ds = E.GetDataSet(file);
Int32 expectedNoTables = 1;
Assert.AreEqual<Int32>(expectedNoTables, ds.Tables.Count);
Assert.IsTrue(ds.Tables.Contains(Sheet));
}
public void Test_ExcelReader_GetsColumnNames()
{
ExcelReader.IDataSetReader E = new ExcelReader.ExcelToDataSetReader();
var file = ExcelReaderTest.Properties.Resources.TestWorkbook1;
DataSet ds = E.GetDataSet(file);
DataTable dt = ds.Tables[Sheet];
string[] expectedColumnNames = new string[]{"A", "B", "C", "D", "E"};
string[] actualColumnNames = (from DataColumn col in dt.Columns select col.ColumnName).ToArray();
Assert.IsTrue(expectedColumnNames.SequenceEqual(actualColumnNames));
}
public void Test_ExcelReader_GetsData()
{
ExcelReader.IDataSetReader E = new ExcelReader.ExcelToDataSetReader();
var file = ExcelReaderTest.Properties.Resources.TestWorkbook1;
DataSet ds = E.GetDataSet(file);
DataTable dt = ds.Tables[0];
Assert.AreEqual<string>("A1", dt.Rows[0].Field<string>(0));
Assert.AreEqual<string>("A4", dt.Rows[3].Field<string>(0));
Assert.AreEqual<string>("A8", dt.Rows[7].Field<string>(0));
Assert.AreEqual<string>("C4", dt.Rows[3].Field<string>(2));
Assert.AreEqual<string>("C5", dt.Rows[4].Field<string>(2));
Assert.AreEqual<string>("C6", dt.Rows[5].Field<string>(2));
Assert.AreEqual<string>("C7", dt.Rows[6].Field<string>(2));
Assert.AreEqual<string>("D1", dt.Rows[0].Field<string>(3));
Assert.AreEqual<double>(4, dt.Rows[3].Field<double>(3));
Assert.AreEqual<double>(5, dt.Rows[4].Field<double>(3));
Assert.AreEqual<double>(6, dt.Rows[5].Field<double>(3));
Assert.AreEqual<double>(7, dt.Rows[6].Field<double>(3));
Assert.AreEqual<double>(8, dt.Rows[7].Field<double>(3));
Assert.AreEqual<string>("E1", dt.Rows[0].Field<string>(4));
Assert.AreEqual<string>("E4", dt.Rows[1].Field<string>(4));
Assert.AreEqual<string>("E3", dt.Rows[2].Field<string>(4));
}
public void Test_ExcelReader_GetsEmptyCells()
{
ExcelReader.IDataSetReader E = new ExcelReader.ExcelToDataSetReader();
var file = ExcelReaderTest.Properties.Resources.TestWorkbook1;
DataSet ds = E.GetDataSet(file);
DataTable dt = ds.Tables[0];
Int32 expectedEmptyCellsCount = 24;
int nullValuesCount = 0;
for (int i = 0; i<8;i++)
for (int j =0;j<5;j++)
if (dt.Rows[i].IsNull(j))
nullValuesCount++;
Assert.AreEqual<Int32>(expectedEmptyCellsCount, nullValuesCount);
}