promiseObj.wb.WorkSheet is not a function

[dangear]

Have this error when need to save xls file

TypeError: promiseObj.wb.WorkSheet is not a function
    at /home/dangear/test/xls/node_modules/excel4node/distribution/lib/workbook/builder.js:410:27
    at new Promise (<anonymous>)
    at Object.writeToBuffer (/home/dangear/test/xls/node_modules/excel4node/distribution/lib/workbook/builder.js:402:12)
    at Workbook.write (/home/dangear/test/xls/node_modules/excel4node/distribution/lib/workbook/workbook.js:170:21)
    at readXSL (/home/dangear/test/xls/xls.js:312:5)
    at WriteStream.<anonymous> (/home/dangear/test/xls/xls.js:156:6)
    at WriteStream.emit (events.js:164:20)
    at finishMaybe (_stream_writable.js:616:14)
    at afterWrite (_stream_writable.js:467:3)
    at onwrite (_stream_writable.js:457:7)

...
wb.write('ExcelOut.xlsx', function (err, stats) {
  if (err) {
    console.error(err);
  } else {
    console.log('Done!');
  }
});
...

Node version is 9.3.0

[FlyingPumba]

@dangear I'm having the same problem. Did you manage to solve it ?

[natergj]

@FlyingPumba, could you provide a small gist that I can use to try to replicate this issue?

[dangear]

@FlyingPumba Can you show your code?

[FlyingPumba]

@natergj @dangear Sorry, I don't have a small gist of code to replicate the issue.

Nevertheless, I think I found the cause of the issue. The problem seems to appear on line https://github.com/natergj/excel4node/blob/master/source/lib/workbook/builder.js#L500 this happens when I call workbook.write(...) with a workbook that doesn't have sheets.

You probably meant to write "promiseObj.wb.Worksheet();" instead of "promiseObj.wb.WorkSheet();".
(There is no object WorkSheet in workbook.js: https://github.com/natergj/excel4node/blob/master/source/lib/workbook/workbook.js)

[natergj]

Thanks for finding that @FlyingPumba! I'll get that fixed in the next release

[natergj]

This is now fixed with version 1.5.0

[lenhnv1305]

It seems i meet this error also, my case wb required at least one worksheet, calling wb.addWorksheet(sheetName)