コード例 #1
0
 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);
 }
コード例 #2
0
 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);
 }
コード例 #3
0
 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));
 }
コード例 #4
0
 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));
 }
コード例 #5
0
 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));
 }
コード例 #6
0
 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);
 }