excel icon indicating copy to clipboard operation
excel copied to clipboard

Is there a way to insert lists as columns?

Open azmasamy opened this issue 3 years ago • 2 comments

Proposed function sheetObject.insertColIterables(listData, 0);

azmasamy avatar Jan 01 '21 21:01 azmasamy

@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.

justkawal avatar Jan 16 '21 08:01 justkawal

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

justraman avatar Mar 29 '21 09:03 justraman