This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi All, I'm working with excel file in File Cabinet. Need to know if there is any standard Suitescript 2.0 api's or javascript methods to *decode* and *encode* the file content using BASE64. ??? Can anyone suggest me the best way to achieve the same? Thanks.

you can use N/encode. My warning to you is that it is a waste of time to use it on binary content. only use it on a file that is text

I wanted to access an excel file which is on the file cabinet (read the content from excel sheet, process it and update new columns in the same xlsx file), is there any way I can do using suitescript 2.0 ??

if you want, your best chance in suitescript sheetjs

i personally would recommend not doing the work in suitescript

I have never worked on SheetJs. Do you have a sample/references for the same, it would be helpful for me.

nothing for you, its the only thing i know of that manipulates excel files from javascript