public void ExcelGenerator_GetDataFromString()
{
object result;
result = ExcelGenerator.GetDataFromString("test", typeof(string));
Assert.IsNotNull(result);
Assert.AreEqual(typeof(string), result.GetType());
Assert.AreEqual("test", result);
result = ExcelGenerator.GetDataFromString("1", typeof(int));
Assert.IsNotNull(result);
Assert.AreEqual(typeof(int), result.GetType());
Assert.AreEqual(1, result);
result = ExcelGenerator.GetDataFromString("1.5", typeof(double));
Assert.IsNotNull(result);
Assert.AreEqual(typeof(double), result.GetType());
Assert.AreEqual(1.5, result);
result = ExcelGenerator.GetDataFromString("1.5", typeof(decimal));
Assert.IsNotNull(result);
Assert.AreEqual(typeof(decimal), result.GetType());
Assert.AreEqual(1.5m, result);
result = ExcelGenerator.GetDataFromString("2017-04-30", typeof(DateTime));
Assert.IsNotNull(result);
Assert.AreEqual(typeof(DateTime), result.GetType());
Assert.AreEqual(new DateTime(2017, 04, 30), result);
result = ExcelGenerator.GetDataFromString("2017-04-30T20:53:15", typeof(DateTime));
Assert.IsNotNull(result);
Assert.AreEqual(typeof(DateTime), result.GetType());
Assert.AreEqual(new DateTime(2017, 04, 30, 20, 53, 15), result);
}
