Can Netsuite generated a xlsx file ?
# suitescript
s
Can Netsuite generated a xlsx file ?
c
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
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. 🤭
🤣 1
c
It does the same for me in xls
m
You can use Sheet.js
🤔 1
s
@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"