User Tools

Site Tools

Using the Excel Range Wizard

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).

  1. Create a new EASAP and in the New Application Wizard select Use Excel Range Wizard (2.0), click Finish, and the following screen opens:

  2. Click on the Choose File button and then select the tutorial Excel file, Mortgage Calculator.xls, included with this tutorial. Click Next.
  3. On the Select Excel Ranges screen, we can select the part or parts of our original spreadsheet which we want to expose to Users in our EASAP. For now, we will add just one range of cells to the EASAP.
  4. Click on the Add a Range from Excel button ( Add Range ).
  5. The Mortgage Calculator.xls file will open in Excel; select cells A1 through G23 by clicking and dragging to highlight these cells.
  6. Click on Finish button to process our selections and exit the Excel Range Wizard.
  7. The EASAP Builder window will appear and the EASAP Tree will be populated with new objects created by the wizard.
  8. Now let's save our work by clicking on the Save button ( Save ).
  9. At this time, the NAMED RANGE LIST will be created, or updated if already existed, and dependency calculation will be initiated.

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.