Menu
I want to access Google Spreadsheets using JavaScript only (no .NET, C#, Java, etc.)
I came here and was shocked to know that there is NO API for JavaScript to access Google Sheets.
Please tell me how to access (CREATE/EDIT/DELETE) Google Sheets using JavaScript or any of its frameworks like jQuery.
690
The basic premise is that you need to do the following: Set up a Google Sheet for public access (there's a guide on the GitHub project's readme file) Add the npm package to your repository. Call the reader function and pass in a set of options and a callback function to handle the results.
Click “Share” at the top. Then, click “Change” in the Get Link section of the pop-up window. On the right side, click the Editor drop-down arrow and choose “Viewer.” Click “Done” to save your changes.
On your computer, go to docs.google.com/spreadsheets/. Open or create a sheet. Select a cell. Type = followed by the sheet name, an exclamation point, and the cell being copied.
I have created a simple javascript library that retrieves google spreadsheet data (if they are published) via the JSON api:
https://github.com/mikeymckay/google-spreadsheet-javascript
You can see it in action here:
http://mikeymckay.github.com/google-spreadsheet-javascript/sample.html
145
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
