There's a file.Type.EXCEL that you can use to generate an excel file. I used .xls but I don't know the specifics between xlsx and xls.
n
NElliott
12/16/2021, 5:38 PM
The only issue I encountered was naming it .xlsx and using the type "EXCEL", Excel moaned that the filetype was not the same as the content but you just tell it to get on with it and it loads fine. ðŸ¤
@creece more explictly, you'd download this from npm, put in on filecabinet and use it with suitescript 2.1 as an external library via shim then use it's functions... you would normally otherwise get the filetype error because xlsx is "encrpyted"