Unable to open Excel file from sharepoint using JSL JMP code.
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 R
...