@shusson You can try the following code, I will create a pull request as soon as possible, Of course, we are also very happy to accept your contribution 😄.

(async () => {
  var options = {
    filename: './ownerTest/demoTest/read/issue_1277.xlsx',
    useStyles: true,
    useSharedStrings: true
  }
  var wb = new Excel.stream.xlsx.WorkbookWriter(options);
  var ws = wb.addWorksheet('bort');
  var rows = [
    [5,'Bob',new Date()],
    [6,'Bo2b',new Date()]
  ];
  rows.forEach((row) => {
    ws.addRow(row)
  })
  wb.commit();
})()

thanks @Alanscut, but as I understand it committing the workbook will lock the worksheet. i.e I won't be able to add any more rows.

I'll look at opening a PR.

After some investigation it looks like there isn't any performance benefit between committing all the rows together vs committing each row (using WorksheetWriter._stream.write). So for now I'll continue using addRow(...).commit(...). But it would be nice to update the typescript definitions to exclude addRows from the stream worksheet class.

Any progress here? 😿

addRows(value, style = 'n') {
const rows = [];
value.forEach(row => {
rows.push(this.addRow(row, style));
});
return rows;
}

guys we need this feature, please implement 'addRows'