Spreadsheets converted to web pages can run on servers with ASP/ASP.NET. In this case, default values can be taken from a database or provided by any other live data source.
This tutorial is not actively updated for new versions of ASP.Net, Visual Studio or SpreadsheetConverter. It is still correct when it comes to the basic integration principles.
When you use a version of SpreadsheetConverter that does its calculations in the browser, you must provide all default values in the spreadsheet that is downloaded to the browser. There is no communication between the client and server after that.
The ASP/ASP.NET version of SpreadsheetConverter runs in the webserver, and does all calculations there. That means that it can get data from practically anywhere in the server environment for use in the calculator.
This tutorial shows how you can initialize cell values in a spreadsheet stored on a server. You will need some basic programmer’s skills to do this and some experience of web server programming.
We have created a simple calculator, where an interest rate varies for every day. If we store the current interest rate in the spreadsheet, we have to regenerate the webpage every day.
This simple example showed you how simple it is to provide dynamic data from the ASP/ASP.NET environment and feed into the calculator. The code used in this tutorial can easily be enhanced so that the interest is taken from a database or provided by any other live data source.