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