GetGoogleSpreadsheet
result = GetGoogleSpreadsheet(DOCID)
[DOCID] A value like '0AmQ013fj5234gSXFAWLK1REgwRW02hsd3c', which is found in your spreadsheet's url: https://docs.google.com/spreadsheets/d/<here>/edit#gid=0.
[result] cell array of the the values in the spreadsheet
IMPORTANT: The spreadsheet must be shared with the "anyone with the link" option.
This has no error handling and has not been extensively tested.
Please report issues in comments below.
Thanks to @MarkTomaszewski and @Constantine for noting the updated url format (the above description has been updated to reflect this).
Zitieren als
Daniel (2024). GetGoogleSpreadsheet (https://www.mathworks.com/matlabcentral/fileexchange/39915-getgooglespreadsheet), MATLAB Central File Exchange. Abgerufen.
Kompatibilität der MATLAB-Version
Plattform-Kompatibilität
Windows macOS LinuxKategorien
- MATLAB > Data Import and Analysis > Data Import and Export > Standard File Formats > Spreadsheets >
- Reporting and Database Access > Database Toolbox >
- Computational Finance > Database Toolbox >
- MATLAB > External Language Interfaces > Other languages > Google >
Tags
Quellenangaben
Inspiriert: Matlab to Google Sheets (matlab2sheets)
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!Live Editor erkunden
Erstellen Sie Skripte mit Code, Ausgabe und formatiertem Text in einem einzigen ausführbaren Dokument.
Version | Veröffentlicht | Versionshinweise | |
---|---|---|---|
1.0.0.0 | minor reformat description update description as suggested by commenters |