This example demonstrates the Actuate e.Spreadsheet Engine's ability to dynamically generate a richly formatted Excel spreadsheet report and deliver it to an Excel client through a Web browser.

The Actuate e.Spreadsheet Engine API is used in a servlet to read in an e.Spreadsheet Design file (.sod). The design file defines a connection to a data source (this can also be externalized) and defines the report layout. The query defined in the design is executed and the spreadsheet is recalculated and delivered to the requesting client as a rich Excel file with formulas and formatting intact.

In order to view this demo, you will need Excel 97, or more current version, installed.