public void TestFailedToReadNotFoundSheet()
{
using(var wb = new XLWorkbook())
{
Assert.That(() => wb.ReadSheet<NotFoundSheet>(),
Throws.Exception.TypeOf<NotFoundSheetException>());
}
}
public void TestAllowedEmptyCell()
{
using(var wb = new XLWorkbook())
{
var ws = wb.Worksheets.Add("allowed_empty");
ws.Cell("A1").SetValue("@start");
ws.Cell("B1").SetValue("Data");
ws.Cell("A2").SetValue("a");
Assert.DoesNotThrow(() => wb.ReadSheet<AllowedEmptySheet>());
}
}
public void TestEnumValueColumn()
{
using(var wb = new XLWorkbook())
{
var ws = wb.Worksheets.Add("enum_value_column");
ws.Cell("A1").SetValue("@start");
ws.Cell("B1").SetValue("Kind");
ws.Cell("B2").SetValue("Foo");
ws.Cell("B3").SetValue("Bar");
var data = wb.ReadSheet<EnumValueColumnSheet>();
Assert.That(data[0].Kind, Is.EqualTo(DataKind.Foo));
Assert.That(data[1].Kind, Is.EqualTo(DataKind.Bar));
}
}
public void TestReadCommentSheet()
{
using(var wb = new XLWorkbook())
{
var ws = wb.Worksheets.Add("comment_sheet");
ws.Cell("A1").SetValue("@start");
ws.Cell("B1").SetValue("Column");
ws.Cell("A2").SetValue("#comment out");
ws.Cell("B2").SetValue("1");
ws.Cell("B3").SetValue("2");
var data = wb.ReadSheet<CommentSheet>();
Assert.That(data.Count, Is.EqualTo(1));
Assert.That(data[0].Column, Is.EqualTo("2"));
}
}
public void TestNotAllowedEmptyCell()
{
using(var wb = new XLWorkbook())
{
var ws = wb.Worksheets.Add("not_allowed_empty");
ws.Cell("A1").SetValue("@start");
ws.Cell("B1").SetValue("Data");
ws.Cell("A2").SetValue("a");
Assert.That(() => wb.ReadSheet<NotAllowedEmptySheet>(),
Throws.Exception.TypeOf<NotAllowedEmptyException>()
.And.Property("ColumnLetter").EqualTo("B")
.And.Property("RowNumber").EqualTo(2));
}
}
public void TestRowNumberSheet()
{
using(var wb = new XLWorkbook())
{
var ws = wb.Worksheets.Add("row_numbers");
ws.Cell("A1").SetValue("@start");
ws.Cell("B1").SetValue("Data");
ws.Cell("B2").SetValue("1");
ws.Cell("B3").SetValue("2");
var data = wb.ReadSheet<RowNumberSheet>();
Assert.That(data[0].Data, Is.EqualTo(1));
Assert.That(data[0].RowNumber, Is.EqualTo(2));
Assert.That(data[1].Data, Is.EqualTo(2));
Assert.That(data[1].RowNumber, Is.EqualTo(3));
}
}
public void TestReadTwoColumnSheet()
{
using(var wb = new XLWorkbook())
{
var ws = wb.Worksheets.Add("two_column");
ws.Cell("A2").SetValue("@start");
ws.Cell("B2").SetValue("column1");
ws.Cell("C2").SetValue("Column2");
ws.Cell("B3").SetValue("1");
ws.Cell("C3").SetValue("b3");
ws.Cell("B4").SetValue("2");
ws.Cell("C4").SetValue("b4");
var data = wb.ReadSheet<TwoColumnSheet>();
Assert.That(data[0].Column, Is.EqualTo("1"));
Assert.That(data[0].Column2, Is.EqualTo("b3"));
Assert.That(data[1].Column, Is.EqualTo("2"));
Assert.That(data[1].Column2, Is.EqualTo("b4"));
}
}
public void TestReadOneColumnSheet()
{
using(var wb = new XLWorkbook())
{
var ws = wb.Worksheets.Add("one_column");
ws.Cell("A1").SetValue("@start");
ws.Cell("B1").SetValue("column");
ws.Cell("B2").SetValue("1");
ws.Cell("B3").SetValue("2");
var data = wb.ReadSheet<OneColumnSheet>();
Assert.That(data[0].Column, Is.EqualTo("1"));
Assert.That(data[1].Column, Is.EqualTo("2"));
}
}
public void TestReadIndexedColumnSheet()
{
using(var wb = new XLWorkbook())
{
var ws = wb.Worksheets.Add("indexed_column_sheet");
ws.Cell("A1").SetValue("@start");
ws.Cell("B1").SetValue("column0");
ws.Cell("B2").SetValue("0");
ws.Cell("C1").SetValue("column1");
ws.Cell("C2").SetValue("1");
ws.Cell("D1").SetValue("column2");
ws.Cell("D2").SetValue("2");
var data = wb.ReadSheet<IndexedColumnSheet>();
Assert.That(data[0].Column["column0"], Is.EqualTo("0"));
Assert.That(data[0].Column["column1"], Is.EqualTo("1"));
Assert.That(data[0].Column["column2"], Is.EqualTo("2"));
}
}
public void TestReadDateTimeSheet()
{
using(var wb = new XLWorkbook())
{
var ws = wb.Worksheets.Add("date_time_sheet");
ws.Cell("A1").SetValue("@start");
ws.Cell("B1").SetValue("Time");
ws.Cell("B2").SetValue("2014/07/07 10:10:10");
ws.Cell("B3").SetValue("2014/10/1");
var data = wb.ReadSheet<DateTimeSheet>();
Assert.That(data[0].Time, Is.EqualTo(DateTime.Parse("2014/07/07 10:10:10")));
Assert.That(data[1].Time, Is.EqualTo(DateTime.Parse("2014/10/1")));
}
}
