Accessing excel from file from sharepoint does not work

Hello,

the following code tries to open an excel file from some sharepoint location and to store it to disk. The result is a totally corrupted file that doesn't contain any data:

Excel=actxserver('Excel.Application');
EWorkBooks=Excel.Workbooks;
EFile=EWorkBooks.Open(<Sharepoint link to Excel file>);
EFile.SaveAs(<local disk location>);
EFile.Close;
Excel.Quit;

Opening the Excel file by hand on the sharepoint shows a file that is totally fine and not corrupted.

This code, however tries to open a word file from the exact same sharepoint location and to store it to disk. It works perfectly fine:

Word=actxserver("Word.Application");
Wordfile=Word.Documents.Open(<Sharepoint link to Word file>);
Wordfile.SaveAs2(<local disk location>);
Wordfile.Close;
Word.Quit;
delete(Word);

What am I doing wrong with the excel file?

[Sara Boznik]

Maybe you should try with xlsread.

[Lionel Pöffel]

xlsread obviously can't acess sharepoint links:

[Sebastian Stumpf]

Hi,

did you fix the problem? I also would like to access an Excel-File which is stored in Microsoft OneDrive, but not locally. I have the link of the Excel-File. I just want to read the data from it.

Thanks

Best regards,

Sebastian

[Lionel Pöffel]

Yes. It turned out that documents created out of an associated TEAMs channel obtained unresolvable script-like links. Documents need to be explicitly uploaded onto the sharepoint out of the sharepoint GUI. Then they seem to obtain resolvable links.