RW-DiefBell
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'); ```
This is just to test