search

mgcrea / node-xlsx

NodeJS excel file parser & builder
Other
2.96k stars 274 forks source link

Parse can't fill the blank cells #165

Closed zxq08 closed 2 years ago

zxq08 commented 2 years ago

if my Excel has blank cells, they will be ignored, which may cause dislocation。

zxq08 commented 2 years ago

And I see XLSX docs has a option key which called "defval". But your parse method doesn't support. Anyway，I'm using XLSX Instead of yours and I hope you can fix this~

zxq08 commented 2 years ago

And sorry for my poor English... I hope you can understand it.

LucasDelboni commented 2 years ago

I was with the same problem. I figured out that if you send the parameter {sheetStubs:true} to the XLSX's method readFile it read empty cells as null. And you can pass parameter to the XLSX's method readFile.

So, if you want to continue using node-xlsx, you can just call this way: nodeXlsx.parse('filename', {sheetStubs:true});

stale[bot] commented 2 years ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.