Guyon Roche
Guyon Roche
This is because Pivot Tables are not yet supported by exceljs. Looking at the pivot table structures in an xlsx file it looks quite involved, I'm not sure when I...
I take it you mean 80 million rows? That would be difficult with this library as it is since it is designed as a document editor, not a streaming parser....
Just in case you're still watching this issue - I've just published 0.2.0 which is step 1 on the way to your 80M rows. It's not quite there yet as...
Further update: The zipping is fixed and now very large spreadsheets can be written - I tested it with 100M rows of 10 cells each! Still working on the parsing...
I have to admit - I haven't been able to look at this for a while but it is an itch that won't go away. I'm hoping to address this...
@t1hk I can't seem to reproduce your issue. I copied your code and the spreadsheet looks fine: 
@akramhussein - I've just published 0.4.2, which I'm hoping will resolve this issue. I'm not sure about the pivot tables, ExcelJS doesn't handle them explicitly but there was an issue...