Guide

Embedding Google Spreadsheets

Generic Method

From Google Sheets, use File, Publish to the Web to get the Embed code (the iframe link)
In your web page, switch to Text view and paste the iframe link.

Flip Horizontal Scroll Bars to Top Method

Use Generic Method to embed a sheet.

Next, follow the steps below to create a shortcode similar to the one shown in the example below.

Modify the iframe link as follows:
– add class=”Content” height=”1400″ width=”1640″ after the iframe tag
– using square brackets, add an embed_sheet shortcode above and below the iframe – make the bottom short code a closing one /embed_sheet
– for the top shortcode, add a sheet_height=”” parameter

Adjust the 3 height/width variables
embed code height – make this 50px higher than the iframe height
iframe height – big enough to show all of spreadsheet without internal iframe scroll bars
iframe width – full width of underlying sheet – try 1500px to start

embed_sheet-shortcode