Forum Discussion

deepa_samota's avatar
deepa_samota
Contributor
3 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
Icon for Champion Level 3 rankChampion Level 3
3 years ago

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