Dropbox is removing the ability to host calculators on the web from your Dropbox account. All existing calculators in Dropbox will soon disappear from the web. The information below is therefore partly inapplicable.
We are developing a similar click-to-publish solution specifically for WordPress, where the calculator or form is hosted on the WordPress server. We also consider developing a more generic solution, similar to the Dropbox connection we had in the past.
Meanwhile, we suggest you try to upload your converted calculator to your own website or blog.
The easiest way to import an Excel calculator, live chart or smart form into almost any blog or website is to use SpreadsheetConverter. This tutorial will show you how to publish live Excel spreadsheets and charts in almost any blog or website.
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 HTML web pages, that can easily be imported into almost any blog or website.
Most websites 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!
With this clever Excel plugin you can also create advanced tables, import complex charts or open live graphs in websites.
Converting the spreadsheet to an HTML file was simple with SpreadsheetConverter HTML. We just opened the calculator in Excel and pressed the Convert button in the SpreadsheetConverter ribbon.
SpreadsheetConverter offers click-to-publish sharing with Dropbox, a cloud service for file sharing. Dropbox includes enough free storage to hold hundreds of live calculators and web forms. Once we had converted the spreadsheet to web format we could make it immediately available on the web using a Dropbox account as a web server.
If you’re unfamiliar with Dropbox sharing, you may want to read the tutorial on how to publish Excel spreadsheets on the web using Dropbox before you continue.
When we uploaded the calculator to Dropbox, we saved the public link to the calculator, since we intended to use this link to show the calculator in an iframe.
With the help of an iframe, we can now show our calculator in almost any other web or blog page. The iframe is a “viewport” that shows the content of another page.
Into the iframe statement, we pasted the URL to the page in Dropbox that we saved when we had uploaded it. We also adjusted the height and width of the iframe to avoid scrolling. The iframe statement finally looked like this:
<iframe frameborder="0" width="600px" height="300px" src="http://dl.dropboxusercontent.com/spa/vs1elwxtup0687j/sample/sample.htm"> </iframe>
You don’t have to use Dropbox. If you manually upload the converted web page to another web server, just replace the Dropbox URL in the example above with a link to your web calculator.
Inserting the calculator into Blogger
In Blogger, we inserted the iframe source code directly in the HTML view.
In Drupal, we had to set the input format to “Full HTML” before we inserted the iframe source code directly in the HTML view.
In Joomla, the HTML editor removes the iframe tag by default. We had to turn this feature off to be able to insert the iframe tag. We went to “Extensions > Plugin Manager > Editor > TinyMCE“ and located the “Code cleanup on save” option, which we set to “Never”.
We could then paste the iframe source code into the HTML Source Editor, click Update and save the article.
In Squarespace, we inserted the iframe source code directly in the “Raw HTML” view.
In TypePad, we inserted the iframe source code directly in the “Raw HTML” view.
In WordPress, we inserted the iframe source code directly in the HTML view. We then clicked Update without going to the Visual view, which otherwise would have removed the iframe.
We opened each 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 Sales tax 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.