Embeds a published, public Google Spreadsheet in a WordPress post or page as an HTML table.
Yes, if you're able to change your theme's style sheet. The plugin renders HTML with plenty of CSS hooks. Use the igsv-table class from your style sheets to target the plugin's <table> element.
Additionally, each row (<tr>) and cell (<td>) is assigned a specific class attribute value. The first <tr> element is assigned the row-1 class, the second is assigned row-2, and the last row-N where N is the number of rows in the rendered table. Similarly, each cell is assigned a class based on its columnar position; the first cell in a row is assigned the col-1 class, the second col-2, and so on:
.igsv-table .row-2 .col-5 { /* styles for the cell in the 2nd row, 5th column */ }
Finally, both rows and cells (based on columns) are assigned an additional class of either odd or even, allowing for easy zebra-striping in CSS3 non-conformant browsers.
.igsv-table tr.odd { /* styles for odd-numbered rows (row 1, 3, 5...) */ }
.igsv-table tr.even { /* styles for even-numbered rows (row 2, 4, 6...) */ }
.igsv-table td.odd { /* styles for odd-numbered cells (column 1, 3, 5...) */ }
.igsv-table td.even { /* styles for even-numbered cells (column 2, 4, 6...) */ }
You should triple-check that you've published your spreadsheet. Google provides instructions for doing this. Be sure to follow steps 1 and 2 in Google Spreadsheets Help: Publishing to the Web.
While you can't strip out columns like you can do with rows, you can hide columns using CSS with code such as, .col-4 { display: none; }, for example.
Requires: 2.7 or higher
Compatible up to: 3.3.2
Last Updated: 2012-4-25
Downloads: 3,722
0 of 1 support threads in the last three weeks have been resolved.
Got something to say? Need help?