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

There's nothing wrong with the file, it opens fine in Excel.

 

  • deepa_samota's avatar
    deepa_samota
    Contributor
    2 years ago

    After saving file trying to open that time getting error

     

    aqFile.WriteToTextFile(latestFile.ParentFolder.Path+ "\\test.xls", m, aqFile.ctUTF8);
    myFile.Close();
    var excelFile = Excel.Open("C:\\temp\\3359398_a978ca61-4470-42ba-83fe-73c98ca22748\\test.xls");