public void ExcelDataReaderReadTreatTextNullAsNull()
{
ExcelFile setting = new ExcelFile();
setting.FileName = System.IO.Path.Combine(m_ApplicationDirectory, "BasicExcel.xls");
setting.SheetName = "Basic";
// setting.TreatTextNullAsNull = true;
using (ExcelFileReaderInterop test = new ExcelFileReaderInterop())
{
test.Open(setting, CancellationToken.None, true);
test.Read();
Assert.AreEqual(1, test.GetInt32(0));
Assert.AreEqual("German", test.GetString(1));
Assert.AreEqual(new DateTime(1901, 1, 5), test.GetDateTime(2));
Assert.AreEqual(276d, test.GetDouble(3));
Assert.AreEqual(0.94, test.GetDouble(4));
Assert.AreEqual(true, test.GetBoolean(5));
test.Read();
test.Read();
Assert.AreEqual(4, test.GetInt32(0));
Assert.IsTrue(test.IsDBNull(1));
Assert.IsTrue(string.IsNullOrEmpty(test.GetString(1)));
Assert.AreEqual(DBNull.Value, test.GetValue(1));
Assert.IsTrue(test.IsDBNull(2));
Assert.AreEqual(true, test.GetBoolean(5));
test.Read();
test.Read();
Assert.IsTrue(string.IsNullOrEmpty(test.GetString(1)));
Assert.AreEqual(DBNull.Value, test.GetValue(1));
}
}
