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