public void Should_return_keyvaluepairs_for_xls() { using (FileStream stream = new FileStream(testFileXls, FileMode.Open, FileAccess.Read)) { import.Open(stream, ExcelFileType.XLS, true); var values = import.GetRowsAsKeyValuePairs(0); Assert.That(values, Is.Not.Empty); } }
public void Should_return_expected_values_for_first_keyvaluepair_set_for_Xlsx() { IList <IDictionary <string, object> > resultSet; using (FileStream stream = new FileStream(testFileXlsx, FileMode.Open, FileAccess.Read)) { import.Open(stream, ExcelFileType.XLSX, true); resultSet = import.GetRowsAsKeyValuePairs(0).ToList(); } CollectionAssert.AreEquivalent(firstRowDictionary, resultSet[0]); }
public void Should_accept_file_stream_from_Excel97() { var import = new ExcelImport(); using (FileStream stream = new FileStream(testFileXls, FileMode.Open, FileAccess.Read)) { import.Open(stream, ExcelFileType.XLS, true); } }
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_create_Xls_Importer_for_Xls_file() { var import = new ExcelImport(); using (FileStream stream = new FileStream(testFileXls, FileMode.Open, FileAccess.Read)) { import.Open(stream, ExcelFileType.XLS, true); Assert.IsInstanceOf(typeof(ExcelXlsImporter), import.ExcelImporter); } }
public void Should_create_Xlsx_Importer_for_Xlsx_file() { var import = new ExcelImport(); using (FileStream stream = new FileStream(testFileXlsx, FileMode.Open, FileAccess.Read)) { import.Open(stream, ExcelFileType.XLSX, true); Assert.IsInstanceOf(typeof(ExcelXlsxImporter), import.ExcelImporter); } }
public void Should_throw_InvalidOperationException_if_hasHeaderRow_is_false_for_XLSX() { import = new ExcelImport(); using (FileStream stream = new FileStream(testFileXlsx, FileMode.Open, FileAccess.Read)) { import.Open(stream, ExcelFileType.XLSX, false); Assert.Throws <InvalidOperationException>(() => import.GetRowsAsKeyValuePairs(1)); } }
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_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_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_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_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_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_throw_InvalidOperationException_if_hasHeaderRow_is_false_for_XLSX() { import = new ExcelImport(); using (FileStream stream = new FileStream(_testFileXlsx, FileMode.Open, FileAccess.Read)) { import.Open(stream, ExcelFileType.XLSX, false); Assert.Throws<InvalidOperationException>(() => import.GetRowsAsKeyValuePairs(1)); } }
public void Should_return_keyvaluepairs_for_xlsx() { var import = new ExcelImport(); using (FileStream stream = new FileStream(_testFileXlsx, FileMode.Open, FileAccess.Read)) { import.Open(stream, ExcelFileType.XLSX, true); var values = import.GetRowsAsKeyValuePairs(0); Assert.That(values, Is.Not.Empty); } }
public void Should_throw_exception_if_file_stream_for_xls_null() { var import = new ExcelImport(); Assert.Throws <ArgumentNullException>(() => import.Open(null, ExcelFileType.XLS, true)); }
public void Should_throw_exception_if_file_stream_for_xls_null() { var import = new ExcelImport(); Assert.Throws<ArgumentNullException>(() => import.Open(null, ExcelFileType.XLS, true)); }