How do I create a JMP script to import multiple Excel workbooks from SharePoint?
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 from the JMP Community to help me, thank you everyone!! The script: hard codes the file names and SharePoint pathsopens the SharePoint sitelocates the excel fileopens/imports the Excel file However there are 2 iss...