public void ExcelReader_WithSingleCellSelection_GetsTable() { var selection = new Selection { StartColumn = 1, StartRow = 1, ColumnCount = 1, RowCount = 1 }; var table = _sut.GetExcelTable(_worksheet, selection); Assert.That(table.SheetName, Is.EqualTo("WorksheetName")); Assert.That(table.Rows.Count, Is.EqualTo(1)); Assert.That(table.Rows[0].Columns.Count, Is.EqualTo(1)); Assert.That(table.Rows[0].Columns[0].Text, Is.EqualTo("1 1")); }
public Table GetExcelTable(IWorksheet worksheet, Selection selection) { Table table = new Table(worksheet.Name, selection.ColumnCount, selection.RowCount); int rowOffset = selection.StartRow; int columnOffset = selection.StartColumn; for (int i = 0; i < selection.RowCount; i++) { for (int j = 0; j < selection.ColumnCount; j++) { var excelCell = worksheet.Cells[i + rowOffset, j + columnOffset]; table.Rows[i].Columns[j] = ExtractExcelCellProperty(excelCell); } } return table; }
public void ExcelReader_WithFullWorksheetRangeSelection_GetsTable() { var selection = new Selection {StartColumn = 1, StartRow = 1, ColumnCount = 4, RowCount = 3}; var table = _sut.GetExcelTable(_worksheet, selection); Assert.That(table.SheetName, Is.EqualTo("WorksheetName")); Assert.That(table.Rows.Count, Is.EqualTo(3)); for (int i = 0; i < selection.RowCount; i++) { Assert.That(table.Rows[i].Columns.Count, Is.EqualTo(4)); for (int j = 0; j < selection.ColumnCount; j++) { Assert.That(table.Rows[i].Columns[j].Text, Is.EqualTo(string.Format("{0} {1}", i + 1, j + 1))); } } }