This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
JMP recently got a built-in ability to open Google sheets. Before that in scripts I was calling an R package called Googlesheets to open them. Now my company is moving to office365 so w...
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 ),
Creat...
Hi, I am in progress of transferring my scripts to the companies new office365 account. I would like to be able to access and execute the jsl's (and csv's, html,s) directly from sharepoint...
I am looking to run a script routinely from an excel file we keep in sharepoint. I have not been able to find much but due to the tight control of our IT department I cannot write anything o...
...ompanies have access to a common Excel file via Sharepoint. I have been given access to the file on Sharepoint. After much ‘messing’ and then finding the Web() function, I am now able to get the Excel file t...
...able using the Open() function. However, instead of opening the actual data table, it downloaded like a temporary copy of the table from sharepoint as I see that the table name became "Untitled $$$".&n...
Hi there, used the search functionality but did not find a related topic, please correct me if I am wrong. We have different SharePoint lists and libraries which I would like to u...
I've built an auto-update feature into an add-in. The new version of the add-in is stored on a sharepoint. I am able to open jmp tables from the sharepoint just fine, but am unable to open the a...
My company recently began the migration from SharePoint 2010 to SharePoint Online. I have found that my JSL scripts are now no longer able to open or save files to the new SPO site. A...
Hi Everyone,
I have several Excel o365 workbooks stored in SharePoint that I need to load to JMP and rename each table based on the filename of the excel workbook.
I found code snippets f...