Google sheets to table in matlab

13 vues (au cours des 30 derniers jours)
Cristian Tacoronte
Cristian Tacoronte le 13 Oct 2021
Commenté : Dave B le 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!

Réponses (1)

Dave B
Dave B le 13 Oct 2021
  2 commentaires
Cristian Tacoronte
Cristian Tacoronte le 13 Oct 2021
Good Dave !! I have tried both ways and nothing, I just load the html but not the data that is inside the Google Sheets file :(
Dave B
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...

Connectez-vous pour commenter.

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!

Translated by