Clear Filters
Clear Filters

Access Excel-File stored in Microsoft OneDrive

22 views (last 30 days)
Hello all,
I have an Excel-File which is stored in Microsoft OneDrive, but no locally. I have the web-link which leads to the Excel-File. How can I access and store the data in my Matlab Workspace?
xlsread is not working and also websave does not do what I want.
Which code or function may help me to achieve this?
I am using matlab R2023b.
Thank you very much for your help.
Kind regards,
Sebastian
  4 Comments
Dyuman Joshi
Dyuman Joshi on 9 Feb 2024
Could you share the file or the link to it?
Also, please share what the expected output is.
Sebastian Stumpf
Sebastian Stumpf on 27 Feb 2024
Hello,
sorry for the late response. I was on vacation. Please find the link here: LiftCalc License.xlsx
I expect a Matlab Table to look like this:
Thank you for the support.
Kind regards,
Sebastian

Sign in to comment.

Accepted Answer

Walter Roberson
Walter Roberson on 9 Feb 2024
You need to first use websave() or urlread() to read the contents of the file into local memory.
  4 Comments
Sebastian Stumpf
Sebastian Stumpf on 28 Feb 2024
Ok, I understand. This is bad news. Do you have any other idea how to create an Excel-File or similiar table and store it online but in a way that Matlab can access the information stored in this online-table? Reading is enough. No need to write something from Matlab to the table. Thanks
Sebastian Stumpf
Sebastian Stumpf on 12 Apr 2024
I figuered out, that it's working with DropBox. If you have a public link and change the last value db=0 to db=1, you can access the files directly.

Sign in to comment.

More Answers (0)

Products


Release

R2023b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!