topic Re: Unable to open Excel file from sharepoint using JSL JMP code. in Discussions

Unable to open Excel file from sharepoint using JSL JMP code.

Giardini — Fri, 05 Jan 2024 09:43:13 GMT

Attempting to use the following JMP JSL code:

dt = Open("https://name_of_file.xlsx?download=1",
	Worksheets( My_Res ),
	Use for all sheets( 1 ),
	Concatenate Worksheets( 0 ),
	Create Concatenation Column( 0 ),
	Worksheet Settings(
		1,
		Has Column Headers( 1 ),
		Number of Rows in Headers( 1 ),
		Headers Start on Row( 1 ),
		Data Starts on Row( 2 ),
		Data Starts on Column( 1 ),
		Data Ends on Row( 0 ),
		Data Ends on Column( 0 ),
		Replicated Spanned Rows( 1 ),
		Replicated Spanned Headers( 0 ),
		Suppress Hidden Rows( 1 ),
		Suppress Hidden Columns( 1 ),
		Suppress Empty Columns( 1 ),
		Treat as Hierarchy( 1 ),
		Multiple Series Stack( 0 ),
		Import Cell Colors( 0 ),
		Limit Column Detect( 0 ),
		Column Separator String( "-" )
	)
);

generates an error:

Anyone had a similar problem?

Re: Unable to open Excel file from sharepoint using JSL JMP code.

jthi — Fri, 05 Jan 2024 10:13:08 GMT

Anyone had a similar problem? - Yes, this is one fairly commonly asked question. Below are some earlier posts:

And here are some searches which might help you to find those (and others):

Re: Unable to open Excel file from sharepoint using JSL JMP code.

Giardini — Sun, 14 Jan 2024 22:13:05 GMT

Guy, I watched those sides before I wrote here...

The problem turned out to be related to the system settings, unrelated to the JSL JMP language, so I'm closing the thread.

Re: Unable to open Excel file from sharepoint using JSL JMP code.

Steffen_Bugge — Sun, 10 Mar 2024 16:57:01 GMT

I have had similar issues. @GI , what was the problem with the system settings?

Re: Unable to open Excel file from sharepoint using JSL JMP code.

TH2024 — Thu, 21 Mar 2024 11:23:11 GMT

What was the system setting? I'm getting same error with JMP 17 that i was not getting with JMP 16.

Re: Unable to open Excel file from sharepoint using JSL JMP code.

IloinenHamsteri — Wed, 27 Mar 2024 07:00:18 GMT

I have the same issue, any advice in the system settings?

Re: Unable to open Excel file from sharepoint using JSL JMP code.

jthi — Wed, 27 Mar 2024 07:31:42 GMT

If none of the suggestion I did provide (or additional searches from community) didn't help, I suggest contacting JMP Support (and if you get a response/solution post back).

Re: Unable to open Excel file from sharepoint using JSL JMP code.

Steffen_Bugge — Mon, 22 Apr 2024 09:53:53 GMT

Thanks @jthi ! FYI: @IloinenHamsteri @TH2024 @Giardini

Answer from JMP support:

"Due to changes in SharePoint and JMP, the direct web import from SharePoint is no longer possible in JMP.

The work around is to map a network drive to folder on SharePoint containing the Excel file you wish to import. You can then import the Excel file either through Windows Explorer or via a JSL script.

You can see how to use the JMP Excel Import Wizard in this video: https://protect.checkpoint.com/v2/___https://www.jmp.com/en_us/learning-library/topics/jmp-basics/importing-data-from-excel.html___.YzJ1OnNhc2luc3RpdHV0ZTpjOm86NjgxNzc5OGEyMGQwNmE0YjI3NGQ3Zjk2Y2E2Nzg0YTU6NjpkMTk2OjA0Njk1M2Y4ZTFiOWFkYTA4NTA0YThmNzYyNTQxNWVhY2Y2MDdmNmEzYzhlOGRhYWYzZDY1ZjJkMGNiM2Y5Y2E6dDpU

Here is a JMP Community post on how to import Excel using a JSL script: https://protect.checkpoint.com/v2/___https://community.jmp.com/t5/Discussions/how-to-create-a-script-to-import-xls-to-jmp/td-p/276633___.YzJ1OnNhc2luc3RpdHV0ZTpjOm86NjgxNzc5OGEyMGQwNmE0YjI3NGQ3Zjk2Y2E2Nzg0YTU6NjowZDFlOmJkOWE5NzA1OTY0MmZjOGI2OGFiNGExZTFiMmZhZDZmYmFkZWFmNjFiZDUyYTY4YTliNGIzZjhlNDllYWIwZjA6dDpU

We plan to add a SharePoint Connector in a future version of JMP."