excel
excel copied to clipboard
Is there a way to insert lists as columns?
Proposed function sheetObject.insertColIterables(listData, 0);
@azmasamy That would be a awesome feature to provide.
I'll be work on it on weekends, Stay connected, This update will have that functionality.
You can do like this.
var sheet = excel['ColumnIterables'];
var colIterables = ['A', 'B', 'C', 'D', 'E'];
int colIndex = 0;
colIterables.forEach((colValue) {
sheet.cell(CellIndex.indexByColumnRow(
rowIndex: sheet.maxRows,
columnIndex: colIndex,
))
..value = colValue;
});