public static TableSize PlaceTableAxes(this Table table, ExcelWorksheet worksheet, ExcelCoordinate start)
{
table.PlaceZAxis(worksheet, start.Offset(0, 2));
var columns = table.GetColumns();
PlaceColumns(worksheet, columns, start.Offset(2, 2));
var rows = table.GetRows();
PlaceRows(worksheet, rows, start.Offset(3, 1));
var size = new TableSize(columns.Count, rows.Count);
PlaceCellNames(worksheet, rows, columns, table.Code, start.Offset(3, 2));
PlaceDataArea(worksheet, table.Code, start.Offset(3, 2), size);
return(size);
}
private static void PlaceDataArea(ExcelWorksheet worksheet, string tableCode, ExcelCoordinate start, TableSize size) => worksheet.Names.Add(GetDataAreaName(tableCode), worksheet.Cells[start.Row, start.Column, start.Row + size.Rows - 1, start.Column + size.Columns - 1]);
public ExcelCoordinate Add(TableSize size)
{
return(Offset(size.Rows, size.Columns));
}
