public void OpenPathNoHdrSheetNameTest() { var dt = new DataTable(); using (var reader = new ExcelDataReader(@"test.xlsx", "Second", false)) dt.Load(reader); Assert.AreEqual(7, dt.Columns.Count); Assert.AreEqual(6, dt.Rows.Count); }
public void OpenPathHdrDefaultSheetTest() { var dt = new DataTable(); using (var reader = new ExcelDataReader(@"test.xlsx")) dt.Load(reader); Assert.AreEqual(7, dt.Columns.Count); Assert.AreEqual(5, dt.Rows.Count); }
public static DataTable GetDataTable(string FilePath, string SheetName, bool FirstRowAsHeader) { DataTable dt = new DataTable(); using (ExcelDataReader r = new ExcelDataReader(FilePath, SheetName, FirstRowAsHeader)) { dt.Load(r); } return(dt); }
public void DataReaderTest() { using (var reader = new ExcelDataReader(@"test.xlsx")) { Assert.AreEqual(0, reader.Depth); Assert.AreEqual(-1, reader.RecordsAffected); Assert.AreEqual(7, reader.FieldCount); Assert.AreEqual(5, reader.GetOrdinal("ColDecimal")); Assert.AreEqual(-1, reader.GetOrdinal("InvalidColName")); } }
public static DataTable GetDataTable(string FilePath, int SheetIndex, string [] Headers) { DataTable dt = new DataTable(); using (ExcelDataReader r = new ExcelDataReader(FilePath, SheetIndex, false)) { r.Headers = Headers; dt.Load(r); } return(dt); }
public void OpenStreamEmptySheetTest() { var dt = new DataTable(); using (var sr = File.OpenRead(@"test.xlsx")) { using (var reader = new ExcelDataReader(sr, "Third", false)) dt.Load(reader); } Assert.AreEqual(0, dt.Columns.Count); Assert.AreEqual(0, dt.Rows.Count); }
public void OpenStreamHdrSheetIndexTest() { var dt = new DataTable(); using (var sr = File.OpenRead(@"test.xlsx")) { using (var reader = new ExcelDataReader(sr, 1, false)) dt.Load(reader); } Assert.AreEqual(7, dt.Columns.Count); Assert.AreEqual(6, dt.Rows.Count); }
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)); } }