Last active
December 30, 2023 18:52
-
-
Save melissachang/5a9c610a554e566a5f18e62c87329b7d to your computer and use it in GitHub Desktop.
In new Google Sites, embed spreadsheet without scrollbars
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
- In Google Sheet, Publish to Web. Select Embed. I only know how to hide scrollbar with Embed, not Link. Copy iframe html. | |
- In Google Site, insert Embed. Select Embed code. I only know how to hide scrollbar with Embed code, not By URL. | |
- Paste iframe html. | |
- To hide header/footer, change "widget=true&headers=false" to "widget=false&headers=false&chrome=false". See [1]. | |
- Add iframe attributes: width=994 height=500 scrolling="no" frameBorder=0 | |
- Can use Chrome Developer tools to measure width | |
- scrolling="no" hides scrollbars [2] | |
- frameBorder=0 hides iframe border | |
- Extend Google Sites blue box so you can see all of iframe. | |
[1] https://support.google.com/docs/answer/183965?hl=en&co=GENIE.Platform%3DDesktop#zippy=%2Cedit-embedded-spreadsheets:~:text=If%20you%E2%80%99re%20embedding%20a%20spreadsheet | |
[2] https://stackoverflow.com/a/21225147 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment