anyone here have any experience using SheetJS or other excel library to read excel files in NS?

Never used it myself but curious what the use case is for it. I know a lot of people use excel to get their data straight and then export as CSV for upload. You can also generate a pretty basic spreadsheet from netsuite.

A friend of mine had to use it to generate multi-tab compliance reports. IIRC, he had to convert the file to Base64 before saving it to NetSuite, but otherwise I think it worked like the tutorials.

here is an article I recently published: https://nserpsolutions.com/suitescript/scheduled-script/read-create-modify-excel-files-in-suitescript-using-sheetjs/

@creece client wants their customers to be able to upload a Customer Order Form (XLSX) to NS, where one of the tabs is a simplified sheet built using references and have sales orders created in NS

I'm glad it helped. I use it for 2 processes. to calculate exchange rates and import which is coming in excel form and to generate trial balance report (my upcoming articles in progress 🙂 ) that is uploaded to sftp server.

yeah thanks for the article i bookmarked it to take a look when i get some time. I can see that being pretty useful.