cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
ABLizard314
Level I

there was an error opening the excel file

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. 

 

3 REPLIES 3
txnelson
Super User

Re: there was an error opening the excel file

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
Level IV

Re: there was an error opening the excel file

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
Level XII

Re: there was an error opening the excel file

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