The easiest way to import an Excel calculator, live chart or smart form into a WordPress blog or website is to use SpreadsheetConverter Flash (Standard or Professional Edition). This tutorial will show you how to publish live Excel spreadsheets and charts in WordPress as interactive Flash files.
Adding a live calculator or chart to your website adds value to your visitors and makes your website more interactive. SpreadsheetConverter converts Excel spreadsheets, charts and tables to web-ready Flash files, that can easily be imported into your WordPress blog or website.
Most WordPress blogs consist of just text and static images. A simple way to make your blog or website more interesting is to add a live chart, calculator or web form to it. Help your visitors solve their problems or visualize their situation!
To create this tutorial, we took a simple calculator for UK sales tax (value-added tax, VAT) and published it in a WordPress website. To be able to embed the Excel spreadsheet in a web page, we first converted it to Flash using SpreadsheetConverter Flash.
With this clever Excel plugin you can also create advanced tables, import complex charts or open live graphs in WordPress.
WordPress requires a plug-in to embed Flash files. There are several to chose from, but for this tutorial we used a plug-in developed by American web developer Michael Bester.
We downloaded the latest version of this plug-in from http://kimili.com/plugins/kml_flashembed/wp and installed it into our WordPress site.
After installation, we verified that the plug-in was activated. The Flash icon now appeared in the WordPress editor.
Converting the spreadsheet to a Flash file was simple with SpreadsheetConverter Flash. We just opened the calculator in Excel and pressed the Convert button in the SpreadsheetConverter ribbon.
After the conversion, the Flash file and two skeleton HTML files were placed in the designated folder.
To upload the calculator to the WordPress site we logged in to WordPress and selected Media > Add New.
We clicked on the “Select Files” button and pointed to the .swf Flash file that SpreadsheetConverter created. The file was uploaded, and WordPress then told us the “File URL”, i.e. where it had saved the file. We needed to save this location to be able to refer to the Flash file later, so we copied it.
We now had the Flash calculator and the plug-in for embedding Flash files in place on the website. All we needed to do was to use the plug-in to insert the link to the Flash file. We opened the post in the WordPress editor, navigated to the right position and clicked on the Flash icon in the toolbar.
We pasted the URL for the Flash file that we saved after we had uploaded it. We also set the dimensions for the Flash object to avoid scrolling.
We opened the web page in a browser and tested the calculator – it worked great. For every new value we entered into the Price field, it automatically calculated new amounts for VAT and Price, just like Excel.
SpreadsheetConverter can publish almost any Excel calculator, chart, spreadsheet or electronic form on the web. For more examples, visit our Examples library.