Google sheets to table in matlab

4 views (last 30 days)
Cristian Tacoronte
Cristian Tacoronte on 13 Oct 2021
Commented: Dave B on 13 Oct 2021
Hello good!! I am trying to read a google spreadsheet, which is in Google Drive, to read some passwords and thus start a GUI application when I open it. I am using webread (url) where the url is the address of the google file but what I get is the html page. Is there a way to directly get a table where the content of the google file is seen? All the best! and thanks a lot for the help!

Answers (1)

Dave B
Dave B on 13 Oct 2021
  2 Comments
Dave B
Dave B on 13 Oct 2021
I just tried GetGoogleSpreadsheet with a docid of a spreadsheet and it returns an appropriately sized cell array, looks perfect...Is your spreadsheet available via "anyone with the link" sharing? The submission notes that this is a requirement...

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!