RE: Read contents of .xlsx format file from File Cabinet for Scripting

I want to read contents of .xlsx File format located in  File Cabinet. When I am trying to read the contents, its giving single line of random alphabets. I also tried to convert excel format to csv format which in turn gave me file in encrypted format. Also am not able to find any library function for the same. Majorly it is for integration purpose so can’t do it manually. We are fetching file from SFTP.

Any suggestion would be great help as Client is not ready to provide file in csv format.

Rinsy Rookie Asked on October 11, 2022 in SuiteScript.
Add Comment
1 Answers

Essentially, you are asking for javascript to act as an XLSX parser.

This is difficult but there is third-party code to parse this.

Check out this GitHub repo that should do what you are after:
https://github.com/SheetJS/sheetjs

Here is also a live demo of the repo code:
https://oss.sheetjs.com/sheetjs/

How well you can get this to work with NetSuite is the big question, but this should point you in the right direction.

Beginner Answered on October 11, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.