Accessing excel from file from sharepoint does not work

23 次查看（过去 30 天）

Lionel Pöffel 2020-8-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/578439-accessing-excel-from-file-from-sharepoint-does-not-work

评论： Lionel Pöffel 2024-2-9

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?

4 个评论
显示 2更早的评论隐藏 2更早的评论

Sebastian Stumpf 2024-2-9

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 2024-2-9

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.

请先登录，再进行评论。

请先登录，再回答此问题。