Re: there was an error opening the excel file

Report Inappropriate Content · Feb 29, 2024 05:28 PM

I was unable to open an excel file in a script or when I tried to directly open it.

I tried open data file --> all files --> open with excel wizard, but the excel wizard was never launched and I kept getting the error message.

The file format is .xlsx and the file wasn't opened anywhere else.

txnelson · Feb 29, 2024 06:01 PM

You do not use the Excel Wizard in JSL. What you do, is run interactively once, and then go to the Source entry in the data table that was created by the Wizard, and copy the JSL from the Source entry. You then use that JSL in your script to read in the Excel files.

Jim

Mauro_Gerber · Mar 1, 2024 01:43 AM

Question, is the file generated via an other program like Export of a SAP table? It could be that it's actually a XML file that Excel then can interpret even with the .xslx ending.

Try open the file in Excel and save it again. After that, try open it via JSL/JMP.

"I thought about our dilemma, and I came up with a solution that I honestly think works out best for one of both of us"
- GLaDOS

hogi · Mar 1, 2024 12:10 PM

Another posibility:
Sometimes Jmp cannot open an Excel file if the files is opened at the same time in Excel.

there was an error opening the excel file