public void Should_return_correct_data() { var import = new ExcelImport(); using (FileStream stream = new FileStream(testFileXlsx, FileMode.Open, FileAccess.Read)) { import.Open(stream, ExcelFileType.XLSX, true); var firstRow = import.GetRows(1, true).ToList()[0].ToList(); Assert.AreEqual("Bob", firstRow[2]); Assert.AreEqual("01123 1234356", firstRow[12]); var lastRow = import.GetRows(1, true).ToList()[4].ToList(); Assert.AreEqual("Monroe", lastRow[3]); Assert.AreEqual("N", lastRow[18]); } }
public void Should_return_correct_data() { var import = new ExcelImport(); using (FileStream stream = new FileStream(_testFileXlsx, FileMode.Open, FileAccess.Read)) { import.Open(stream, ExcelFileType.XLSX, true); var firstRow = import.GetRows(1, true).ToList()[0].ToList(); Assert.AreEqual("Bob", firstRow[2]); Assert.AreEqual("01123 1234356", firstRow[12]); var lastRow = import.GetRows(1, true).ToList()[4].ToList(); Assert.AreEqual("Monroe", lastRow[3]); Assert.AreEqual("N", lastRow[18]); } }
public void Should_throw_ArgumentExcetion_if_asking_for_header_row_when_file_does_not_have_header_row() { var import = new ExcelImport(); using (FileStream stream = new FileStream(testFileXlsx, FileMode.Open, FileAccess.Read)) { import.Open(stream, ExcelFileType.XLSX, false); Assert.Throws <ArgumentException>(() => import.GetRows(1, true)); } }
public void Should_return_correct_number_of_rows_ignoring_header() { var import = new ExcelImport(); using (FileStream stream = new FileStream(_testFileXlsx, FileMode.Open, FileAccess.Read)) { import.Open(stream, ExcelFileType.XLSX, true); var rows = import.GetRows(1, true); Assert.AreEqual(5, rows.Count()); } }
public void Should_correctly_convert_date_type_to_string() { var import = new ExcelImport(); using (FileStream stream = new FileStream(_testDataTypesXlsx, FileMode.Open, FileAccess.Read)) { import.Open(stream, ExcelFileType.XLSX, true); var row = import.GetRows(1, false).ToList()[0].ToList(); Assert.AreEqual("22/10/2011", row[1]); } }
public void Should_correctly_convert_date_type_to_string() { var import = new ExcelImport(); using (FileStream stream = new FileStream(testDataTypesXlsx, FileMode.Open, FileAccess.Read)) { import.Open(stream, ExcelFileType.XLSX, true); var row = import.GetRows(1, false).ToList()[0].ToList(); Assert.AreEqual("22/10/2011", row[1]); } }
public void Should_return_correct_number_of_rows_with_header() { var import = new ExcelImport(); using (FileStream stream = new FileStream(testFileXlsx, FileMode.Open, FileAccess.Read)) { import.Open(stream, ExcelFileType.XLSX, true); var rows = import.GetRows(1, false); Assert.AreEqual(6, rows.Count()); } }
public void Should_correctly_convert_data_type_to_string() { var import = new ExcelImport(); using (FileStream stream = new FileStream(_testDataTypesXlsx, FileMode.Open, FileAccess.Read)) { import.Open(stream, ExcelFileType.XLSX, true); var row = import.GetRows(1, false).ToList()[0].ToList(); Assert.AreEqual("abcdef", row[0]); Assert.AreEqual("12345", row[2]); Assert.AreEqual("123.45", row[3]); Assert.AreEqual("0778788990", row[4]); Assert.AreEqual("1.99", row[5]); Assert.AreEqual("0.5025", row[6]); } }
public void Should_correctly_convert_data_type_to_string() { var import = new ExcelImport(); using (FileStream stream = new FileStream(testDataTypesXlsx, FileMode.Open, FileAccess.Read)) { import.Open(stream, ExcelFileType.XLSX, true); var row = import.GetRows(1, false).ToList()[0].ToList(); Assert.AreEqual("abcdef", row[0]); Assert.AreEqual("12345", row[2]); Assert.AreEqual("123.45", row[3]); Assert.AreEqual("0778788990", row[4]); Assert.AreEqual("1.99", row[5]); Assert.AreEqual("0.5025", row[6]); } }
public void Should_throw_ArgumentExcetion_if_asking_for_header_row_when_file_does_not_have_header_row() { var import = new ExcelImport(); using (FileStream stream = new FileStream(_testFileXlsx, FileMode.Open, FileAccess.Read)) { import.Open(stream, ExcelFileType.XLSX, false); Assert.Throws<ArgumentException>(() => import.GetRows(1, true)); } }