How to read and edit excel files in microsoft onecloud storage?

I want to read and edit excel file from my microsoft onecloud storage using matlab. I don't know how to allow access for matlab to edit files from my onecloud account. I don't know whether is it done by setting api keys. Also, sepcifying functions, used to read and write into the excel file will be helpful(I don't know if readtable & writetable can be used for online excel files).Please help. Any help would be appreciated.

Answer 1

[Swatantra Mahato]

Hi,

According to this answer, MATLAB should be able to interact with excel files in OneDrive cloud without issues provided the file is not open in another application. You can use the documentation link below for the funcitons available to work with spreadsheets

https://www.mathworks.com/help/matlab/spreadsheets.html

Hope this helps