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