topic Re: JMP 17 Fails to Import Excel File in Discussions

JMP 17 Fails to Import Excel File

TriangularCurve — Wed, 22 Nov 2023 18:36:17 GMT

Hello,

I have an excel file I'm trying to import but I am continuously getting an error stating "There was an error opening the file" with no other information. I have read a few similar threads and none of the issues other people had seem to apply to my situation. The file is not currently opened by someone else, and it is an .xlsx file from the newest version of excel.

I have tried changing the import preferences to no avail. I cannot even get the excel wizard to open, it fails before that.

Re: JMP 17 Fails to Import Excel File

txnelson — Wed, 22 Nov 2023 18:59:58 GMT

Open in Excel, and then use the Excel/JMP addin to read the file into JMP.
Open in Excel, then save to a .csv and then open in JMP
Contact JMP Support to see if they have a solution

Re: JMP 17 Fails to Import Excel File

hogi — Wed, 22 Nov 2023 20:19:26 GMT

@TriangularCurve wrote:
The file is not currently opened by someone else

by yourself - in Excel?

Re: JMP 17 Fails to Import Excel File

TriangularCurve — Wed, 22 Nov 2023 20:24:24 GMT

No, I do not have it open either.

Re: JMP 17 Fails to Import Excel File

TriangularCurve — Wed, 22 Nov 2023 20:27:59 GMT

I will likely have to contact JMP support, as this is meant to be a JSL script and having to open the excel file to transfer it into JMP sort of misses the point. That said, saving as a .csv does work but unfortunately this file updates automatically and I would have to do that everytime I want to open it.

Re: JMP 17 Fails to Import Excel File

hogi — Wed, 22 Nov 2023 20:40:19 GMT

You could try MFI - it uses it's own import sequence for CSV files.

Maybe also a slightly different method for Excel files?

Re: JMP 17 Fails to Import Excel File

briancorcoran — Wed, 22 Nov 2023 20:40:58 GMT

Hi,

I would contact JMP Tech Support at support@jmp.com. Please make sure to tell them what version of JMP and operating system you are using. Particularly on Windows, there are formulas within Excel sheets that sometimes causes JMP to fail to open a file. It is supposed to give a better error message than you are getting.

You do mention that the file is updating automatically. How is this happening? If the program updating the file keeps it open continuously, you will not be able to open it in JMP.

Brian Corcoran

JMP Development

Re: JMP 17 Fails to Import Excel File

TriangularCurve — Wed, 22 Nov 2023 20:43:56 GMT

It gets automatically updated once a day so it is not kept perpetually open. I will reach out to JMP Tech Support because the formula error sounds like the most likely.

Re: JMP 17 Fails to Import Excel File

hogi — Wed, 22 Nov 2023 20:44:12 GMT

- You could also try to split the Excel file (horizontally or vertically :) to find out which part makes the trouble.

- Or copy the data to a new file and try to import that - just to test if it's related to the content or to something in the background.

- Did you try to save it at a different location?

Re: JMP 17 Fails to Import Excel File

TriangularCurve — Wed, 22 Nov 2023 20:47:14 GMT

I did try to save it to a different location and that didn't work. I will try splitting up the data and see if I can make it work. Unfortunately I'm trying to make a dashboard using this data for other users to access so even If i get it to work splitting it up that may not be a viable long term solution.

Thanks for all the help.

Re: JMP 17 Fails to Import Excel File

WebDesignesCrow — Thu, 23 Nov 2023 02:49:38 GMT

If the Excel using macro or Power Query with "auto-refresh mode from external sources" after file open, most probably JMP cannot read it directly through JSL. I think the logic is "Excel is refreshing ..... ~" & JMP is not a software to "Refresh Excel" .

In my case, I still can open it manually in JMP.

Out of curiosity, does "file updates automatically" means the original raw data updated or "cleaned data which has gone through some clean-up/calculation automation in Excel"?