Google sheets to table in matlab
13 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponses (1)
Dave B
le 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 commentaires
Dave B
le 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...
Voir également
Catégories
En savoir plus sur Google dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!