public GetDateTime ( int i ) : System.DateTime | ||
i | int | |
Résultat | System.DateTime |
public void ReadTest() { using (var reader = new ExcelDataReader(@"test.xlsx")) { reader.Read(); Assert.AreEqual(381728, reader.GetInt32(0)); Assert.AreEqual(381728, reader.GetInt64(0)); Assert.AreEqual("Mr Brown", reader.GetString(1)); Assert.AreEqual("Mr Brown", reader[1]); Assert.AreEqual("Mr Brown", reader["Name"]); Assert.AreEqual(new DateTime(1983, 3, 27, 6, 55, 0), reader.GetDateTime(2)); Assert.AreEqual(new Guid("6E2BF784-F116-494A-916D-9DFF9B2A2AA0"), reader.GetGuid(3)); Assert.AreEqual(32, reader.GetInt16(4)); Assert.AreEqual(32, reader.GetInt32(4)); Assert.AreEqual(32, reader.GetInt64(4)); Assert.AreEqual(32, reader.GetByte(4)); Assert.AreEqual(917.68m, reader.GetDecimal(5)); Assert.AreEqual(917.68d, reader.GetDouble(5)); Assert.AreEqual(917.68f, reader.GetFloat(5)); Assert.AreEqual(true, reader.GetBoolean(6)); } }