Number zero written as empty string

[JanneSalo]

It seems that whenever I have 0 as a Number in my data, it's added as an empty string in the sheet. By converting the Number to String, I'm able to work around the issue, but it would be nice to be able to use the correct data type.

I guess the problem is in addRow(): Since the number 0 evaluates to false (while the string "0" doesn't), the value is lost in the addCell call: @_addCell(row[key] || "", col + 1).

[uhucrew]

Here this problem exists too, a zero value should create a number cell with 0 and not an empty cell.
I have attached a simple patch to fix this:

node-xlsx-writestream_zero-as-string.patch.txt

[peebles]

I have this issue as well.

[cscan]

For this issue, I write another module which inherits xlsx-writestream and override the addRow function by modifying the following _addCell statement as:

this._addCell(row[key] || row[key] === 0 ? row[key] : "", col + 1);