There are several solution. For example, you can send them over an URL with the syntax http://www.foo.com/calc.htm?bar=56 will set the field call bar to 56. You name cells in Excel.
This assumes that you are pre-filling an input cell. Here is a better solution that can be used to set any value.
If you know ASP, the simplest solution is to take the HTML page, make it into a ASP-page over replace statements like
p1A1 = 1234
p1A1 = <%= reference to variable which contains the value for cell A1 on sheet 1 %>
where 1234 is the default value that you set in Excel and which you want to read from the database instead.
This solution also works for PHP.
If you want to set constants, see Initialize values on server
In order to view them, you need a local installation of Microsofts web server Internet Information Server (IIS). IIS is not included in Windows XP Home and has to be installed separately in NT4 and Windows 2000.
Here you can read how to install IIS on Windows XP
Here you can read how to install IIS on Vista
We haven’t tested on Sun Java System ASP, so we cannot guarantee that it will work.
You can read more about Sun Java System Active Server Pages 4.0 here:
The HTML-version calculates on the user’s PC, the ASP and JSP version calculates on the server.
Thus, the user get the results instantly in the HTML-version.
If you have created a calculator, and there are some constants you want to set, for example the current rate, then read the following:
Click on Download to install and test this Excel add-in for Windows.
Click on Upload to let us convert a spreadsheet for you for free.