public void AddEntry(List <object> values)
{
ExcelSheet.MoveTo(
UpperLeftRow + (_orientation == TableOrientation.RowHeaders ? 0 : NumEntries + 1),
UpperLeftColumn + (_orientation == TableOrientation.ColumnHeaders ? 0 : NumEntries + 1)
);
for (var idx = 0; idx < (values.Count > NumHeaders ? values.Count : NumHeaders); idx++)
{
if (idx < values.Count)
{
ExcelSheet.ActiveCell.SetValue(values[idx]);
}
ExcelSheet.Move(
_orientation == TableOrientation.RowHeaders ? 1 : 0,
_orientation == TableOrientation.ColumnHeaders ? 1 : 0
);
}
NumEntries++;
ExcelSheet.Move(
_orientation == TableOrientation.RowHeaders ? -values.Count : 0,
_orientation == TableOrientation.ColumnHeaders ? -values.Count : 0
);
}
public void AddHeader(string header)
{
ExcelSheet.MoveTo(
UpperLeftRow + (_orientation == TableOrientation.ColumnHeaders ? 0 : NumHeaders),
UpperLeftColumn + (_orientation == TableOrientation.RowHeaders ? 0 : NumHeaders)
);
ExcelSheet.ActiveCell.SetCellValue(header);
NumHeaders++;
}