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;" width="800" height="600"></iframe></p>


This is the code that displays everything but the fonts: 

<p><iframe src=";single=true&widget=false&headers=false" width="100%" height="800"></iframe></p>