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