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