Archives‎ > ‎

notes

Spreadsheet embeds are coded like this:
<iframe width="660" height="1800" src="https://docs.google.com/spreadsheets/d/1wWM85XP9k45SAhUfx2wyKYFXG2RL9oOXjSOIvGpQ_Kg/pubhtml?gid=28&range=C1%3AG102&amp;single=true&amp;widget=false&amp;headers=false"></iframe>


To get the code from your GOOGLE SPREADSHEET
  1. Publish to Web
  2. Click EMBED
  3. Change "Entire Document" to just the sheet you want to display
  4. Copy the embed code

The spreadsheet will generate soething like 
<iframe src="https://docs.google.com/spreadsheets/d/1wWM85XP9k45SAhUfx2wyKYFXG2RL9oOXjSOIvGpQ_Kg/pubhtml?gid=29&amp;single=true&amp;widget=true&amp;headers=false"></iframe>


Add the follow extra parameters:
  • width="660" height="1800" after the <iframe tag
  • &range=C1%3AG102 after the gid=##
  • set widget=false
So that the code looks more like:
<iframe width="660" height="1800" src="https://docs.google.com/spreadsheets/d/1wWM85XP9k45SAhUfx2wyKYFXG2RL9oOXjSOIvGpQ_Kg/pubhtml?gid=28&range=C1%3AG102&amp;single=true&amp;widget=false&amp;headers=false"></iframe>



Comments