Hello SE Community,
I have a customer who has a lot of their excel data on sharepoint. They want a way to query the same data table once it got updated with new data.
Currently they have to download the excel file again and import it into JMP to do the analysis. With our JMP-laptops, my sharepoint folders live as directories on my computer, so it's easy to do a "multiple file import". However for this customer they are restricted from having directories connected to sharepoint/one drive on their computer. Hence, they have to manually download the files individually and then import it into JMP.
I understand there is a new tool for JMP 19 that solves this issue: https://marketplace.jmp.com/appdetails/OneDrive+and+SharePoint+Data+Connectors
But I was trying to find a way to solve it now.
I've seen this post but have trouble implementing the given solution: https://community.jmp.com/t5/Discussions/Open-microsoft-office-365-cloud-based-excel-from-JMP-JSL/m-p/242367#U242367
any advice would be greatly appreciated.
thank you,
-lovy
