This post will show you how to insert a sortable, filterable table of spreadsheet data into your blog.
Here’s an example:
It uses the Vixo WordPress plugin to embed a table view of a spreadsheet. This is the page we are embedding. With the plugin installed you can use the following shortcode to embed it.
[vixo url="http://wordpress-demo.vixo.com/table/" width="500px" height="300px"]
Once you have installed the plugin get a Vixo spreadsheet:
(this is an embedded spreadsheet control too!)
Set up your table in the spreadsheet – Vixo is just like other spreadsheets you have used so it shouldn’t be a problem:
Here we use functions like link and status.bar to give us text links and the ticks. We also use standard features like bold and number formatting to get things how we like.
There’s one last thing to do. We need to publish the spreadsheet as a table – which we do using the views menu. You can find this at the top right of the menu bar on the spreadsheet:
Set the default view to table and make the table view public. After that then simply give the shortcode the URL of the page you want to embed – give it a height and a width and you are off…
Give it a go.