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