Google sheets to table in matlab
15 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
回答 (1 件)
Dave B
2021 年 10 月 13 日
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 件のコメント
Dave B
2021 年 10 月 13 日
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...
参考
カテゴリ
Help Center および File Exchange で Google についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!