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.
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.
