Let’s assume that we want to reproduce the look and function of our original spreadsheet as part of an EASAP. We can use a wizard to automatically query the spreadsheet, add interface objects to our EASAP, and upload a copy of our original spreadsheet to act as a logic engine for our EASAP. Our EASAP will not only mimic the look of our spreadsheet, but will be linked to the relevant cells in the secured master version of the spreadsheet on the server.
We can initiate the Excel Wizard by either creating a new EASAP and selecting it on the New Application Wizard or opening an existing EASAP in the Builder and clicking Tools→Excel Range Wizard (2.0).
Mortgage Calculator.xls, included with this tutorial. Click Next.
Mortgage Calculator.xlsfile will open in Excel; select cells A1 through G23 by clicking and dragging to highlight these cells.
The EASAP Builder is shown below:
We now have a perfectly functional EASAP. By default, the Excel Range Wizard will attempt to replicate the formatting of the Excel spreadsheet. Let's check it by clicking on the Test Web Browser button as shown below:
Once the test EASAP has opened, try changing some inputs, and then exit the test window.
See how to add more functionality and GUI elements to this EASAP at the Excel Tutorial page.