Google sheets to table in matlab
14 views (last 30 days)
Show older comments
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!
0 Comments
Answers (1)
Dave B
on 13 Oct 2021
You might try this file exchange submission: https://www.mathworks.com/matlabcentral/fileexchange/39915-getgooglespreadsheet
And/Or check out this previous Answers post: https://www.mathworks.com/matlabcentral/answers/496246-import-data-from-google-sheets-to-matlab
2 Comments
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...
See Also
Categories
Find more on Google in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!