[google-drive-embed url=" ?single=true&gid=419657423&range=f2:g6&widget=false&chrome=false" So you can modify the ‘url’ attribute of the shortcode, adding some extra parameters as follows: Instead, we get the whole spreadsheet including access to the monthly sheets holding more of the data. That’s nice, but really we just wanted to direct our viewer to the colored summary on the right. Using the Add Google File button when editing your post, select the spreadsheet to obtain a shortcode similar to this: Either way, we just need to modify the URL in the code. Here, I’m using our Google Drive Embedder plugin for WordPress – but the steps should be almost identical if you’re just using the ‘iframe’ embed code, obtained from Publish in your Google Spreadsheet, to embed in any site. In this tutorial we’ll talk through the available options. You can embed a single sheet and restrict the display to only a rectangle within it. However, you aren’t allowed much control over the appearance of your spreadsheet – which can be inconvenient if you want to direct viewers to a particular part of the sheet.įortunately, there are a few undocumented ways to add a tiny bit more control to the way your spreadsheets appear. A great feature of Google Apps is the ability to embed live spreadsheets in your website, updating automatically whenever your spreadsheet changes.
0 kommentar(er)
