RW-DiefBell

Results 8 comments of RW-DiefBell

I'll take a look shortly, weird issue if it is that though. Running Win 10 MS Office. Unrelated, but you can escape the | in markdown tables by just doing...

Creating the template in Google Sheets has solved the issue. However if I then edit the XLSX (in this case, I was turning it into a table) I don't get...

Also, using your Google sheets method is considerably faster, even when I do the table edit in Excel.

How Excel fixes the sheet when using tables: ``` Removed Records: AutoFilter from /xl/tables/table1.xml part (Table) Removed Records: AutoFilter from /xl/tables/table2.xml part (Table) Removed Records: AutoFilter from /xl/tables/table3.xml part (Table)...

I got it working as above. Just inject the Response into your controller with @Res and then put this at the end of your controller

Have you tried saving your XLSX to a file first? I should point out that all of the XLSX options out there for js are pretty crap so could just...

Are you able to save the spreadsheet to a file? Try ```ts XLSX.writeFile(wb, 'out.xlsx'); ```