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