Forum Discussion

deepa_samota's avatar
deepa_samota
Contributor
2 years ago

Getting error message when trying to read CSV and XLSX file

I am using following script code for reading CSV and XLSX file. Issue with Excel File : JavaScript runtime error. External table is not in the expected format function GetCol1Unique() { var M...
Script Tests
rraghvani's avatar
rraghvani
Champion Level 3
2 years ago

I saved the file using Excel. You will have to write a script to remove quotes and replace tabs with a comma.