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?
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):
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.
I have had similar issues. @GI , what was the problem with the system settings?
What was the system setting? I'm getting same error with JMP 17 that i was not getting with JMP 16.
I have the same issue, any advice in the system settings?
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).
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."
