AnsweredAssumed Answered

How can I control parameters of Google Sheet embedded via external tools

Question asked by Jennifer Chandler on Oct 9, 2019
  1. I am trying to figure out a way to use the external_tools/retrieve? to open a google sheet from Google Drive and still allow me to control the view of the sheet like it would if I used the embed code from google. When I try to use the embed code by fonts don't display properly, but when I use the external tool for Google Drive I can't figure out how to get rid of the letters and numbers headers on the spreadsheet. I also want to be able to set gid=0 or whichever sheet, and I do not want the tabs or menus to show. I am out of ideas.I would also like to be able to specify the range of cells to display. 

 

This is the code from external tools: 

<p><iframe style="width: 800px; height: 600px;" title="FDN1 Week at a Glance" src="/courses/2642453/external_tools/retrieve?display=borderless&amp;url=https%3A%2F%2Fgoogle-drive-lti-iad-prod.instructure.com%2Flti%2Fcontent-view%2Frce%2F28684398" width="800" height="600"></iframe></p>

 

This is the code that displays everything but the fonts: 

<p><iframe src="https://docs.google.com/spreadsheets/d/e/2PACX-1vTlEuW_0tCIxLAaZqZFhBt1cMH75mm0WYCHMJW5tULycs72CnLltkB8HjzJGTxGfGtBrwL1Flm1c4Po/pubhtml?gid=0&range=A1:G15&;single=true&widget=false&headers=false" width="100%" height="800"></iframe></p>

Outcomes