public void TestThatTimeStringConvertToTimeCorrectly()
{
var convertor = new ExcelDataFormatConvertor();
Assert.AreEqual(new TimeSpan(16, 30, 0), convertor.ConvertStringToValue("16:30", typeof(TimeSpan), ExcelColumnFormat.Hours24Time));
Assert.AreEqual(new TimeSpan(16, 30, 0), convertor.ConvertStringToValue("4:30PM", typeof(TimeSpan), ExcelColumnFormat.Hours12Time));
}
public void TestThatBoolStringConvertToBoolCorrectly()
{
var convertor = new ExcelDataFormatConvertor();
Assert.AreEqual(true, convertor.ConvertStringToValue("TRUE", typeof(bool)));
Assert.AreEqual(false, convertor.ConvertStringToValue("FALSE", typeof(bool)));
Assert.AreEqual(false, convertor.ConvertStringToValue("FALSE", typeof(bool?)));
Assert.AreEqual(false, convertor.ConvertStringToValue("FALSE", typeof(bool?)));
Assert.Null(convertor.ConvertStringToValue(null, typeof(bool?)));
}
public void TestThatDateStringConvertToDateCorrectly()
{
var convertor = new ExcelDataFormatConvertor();
Assert.AreEqual(new DateTime(2017, 10, 24), convertor.ConvertStringToValue("10/24/2017", typeof(DateTime), ExcelColumnFormat.Date));
Assert.AreEqual(new DateTime(2017, 10, 2),
convertor.ConvertStringToValue("10/2/2017", typeof(DateTime), ExcelColumnFormat.Date));
Assert.AreEqual(new DateTime(2017, 8, 2, 14, 41, 10),
convertor.ConvertStringToValue("8/2/2017 14:41:10", typeof(DateTime), ExcelColumnFormat.DateTime));
}
public void TestThatDateRangeStringConvertToDateRangeCorrectly()
{
var convertor = new ExcelDataFormatConvertor();
var result = (DateRange)convertor.ConvertStringToValue("10/24/2017 - 10/2/2017", typeof(DateRange));
Assert.AreEqual(new DateTime(2017, 10, 24), result.StartDate);
Assert.AreEqual(new DateTime(2017, 10, 2), result.EndDate);
}
public void TestThatTimeStringConvertToDefaultTimeFormatCorrectly()
{
var convertor = new ExcelDataFormatConvertor();
Assert.AreEqual(new TimeSpan(16, 30, 0), convertor.ConvertStringToValue("16:30", typeof(TimeSpan)));
}
public void TestThatDateStringConvertToDefaultDateFormatCorrectly()
{
var convertor = new ExcelDataFormatConvertor();
Assert.AreEqual(new DateTime(2017, 10, 2), convertor.ConvertStringToValue("10/2/2017", typeof(DateTime?)));
}
