columns property
Gets collection of columns in the table. Read-only.
// Create a new Excel Document.
final Workbook workbook = Workbook(1);
// Accessing sheet via index.
final Worksheet sheet = workbook.worksheets[0];
//Load data
sheet.getRangeByName('A1').setText('Fruits');
sheet.getRangeByName('A2').setText('banana');
sheet.getRangeByName('A3').setText('Cherry');
sheet.getRangeByName('A4').setText('Banana');
sheet.getRangeByName('B1').setText('CostA');
sheet.getRangeByName('B2').setNumber(744.6);
sheet.getRangeByName('B3').setNumber(5079.6);
sheet.getRangeByName('B4').setNumber(1267.5);
sheet.getRangeByName('C1').setText('CostB');
sheet.getRangeByName('C2').setNumber(162.56);
sheet.getRangeByName('C3').setNumber(1249.2);
sheet.getRangeByName('C4').setNumber(1062.5);
// Creates a table with specified name and data range.Adds it to the tables collection.
final ExcelTable table =
sheet.tableCollection.create('Table1', sheet.getRangeByName('A1:C4'));
// Set TableStyle
table.builtInTableStyle = ExcelTableBuiltInStyles.tableStyleMedium10;
// Set Totals
table.showTotalRow = true;
table.columns[0].totalRowLabel = 'Total';
table.columns[1].totalFormula = ExcelTableTotalFormula.sum;
table.columns[2].totalFormula = ExcelTableTotalFormula.average;
//save and dispose.
final List<int> bytes = workbook.saveAsStream();
saveAsExcel(bytes, 'Table.xlsx');
workbook.dispose();
Implementation
late List<ExcelTableColumn> columns;