0

I wish to embed a spreadsheet made on Google Sheets such that it is editable and as "clean" as possible, for this I want to find a way to embed an editable sheet which also doesn't show the Cell numbers or letters (on the side and above).

I have arrived at two different outputs which approximate what I want. By using the link to share with others as such:

<center><iframe width="1000" height="700"  src="[GOOGLE SPREADSHEETS LINK TO SHARE WITH OTHERS]?single=false&widget=false&headers=false&rm=minimal"></iframe></center>

Leads to the following output which is editable enter image description here

By using the link given when you select "publish to the web" as such:

<center><iframe width="1000" height="500"<iframe src="[GOOGLE SPREADHSHEETS LINK TO PUBLISH TO THE WEB]pubhtml?widget=true&amp;headers=false"></iframe></center>

Leads to the following which does not have the cell coordinates but is not editable: enter image description here

Note that: Both HTML codes have the parameter &headers=false which is used for getting rid of the coordinates (it works in the second but not the first)

Is there a way to "combine" both outputs and get an embedding such as the one I am looking for?

D. Brito
  • 164
  • 8
  • removing cols and rows reference defeats the purpose of having an editable spreadsheet, what's your motivation? – David Salomon Apr 11 '22 at 21:14
  • @DavidSalomon it doesn't defeat all the purpose. I would like to be able to edit the cells which are shown on the website but not add any new rows or columns. – D. Brito Apr 29 '22 at 20:17
  • There are many applications for this. In my case, a search bar that populates data based on dropdown selection. Would be nice for it to look like it is part of the site. – Codedabbler Jul 26 '23 at 18:48

1 Answers1

1

Found this similar question and it looks like these parameters are only supported for the “Published” sheets and not the editable link.

You can request this feature to be available through Google Sheets by going to a Google Sheet file, click on ‘Help’ > ‘Help Sheets improve’ and give a description of your request.

Lorena Gomez
  • 1,946
  • 2
  • 4
  • 11