My problem is the following:
- I want to literally extract a spreadsheet from Google Sheet and modify it as if it were there. For better understanding: It's like a YouTube video, that when placed on a web page, you have all the options available as if you were watching it from YouTube.
I fully understand how to publish the data from a spreadsheet on my web page.
I also know that there is a Google Sheets API.
The issue is that I would have to add all the functions manually and it is not the idea to recreate a Google Sheet, but to use it from a part of my web page.
Use a tag
iframe
and give the src attribute the URL of your spreadsheet (to edit it must end in/edit
).To hide the header, menus, and sidebar, add a query-string to the spreadsheet URL with the parameter
rm=minimal
If you want to specify the sheet to display, for example
#gid=0
(hash), the query-string must be given first, and the hash at the endRelated
internal
external