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 ( ).
5. Mortgage Calculator.xls file will open in Excel;
   • Select cells A1 through G23 → click and drag 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 ( ).
9. At this time, the NAMED RANGE LIST will be created, or updated, and dependency calculation will be initiated.
   • For Excel 2013 or 2016 disable hardware graphics acceleration to speed up the Excel Range Wizard 2.0
     • ( In Excel Check File→Options→Advanced→Display→Disable hardware graphics acceleration )

The Excel Range Wizard will mimic the Excel 'look and feel' only it scales them up by 110% (ie. to see how your EASAP will look adjust the scale in Excel to 110%).

Alternatively, Convert a SUB PANE to a LAYOUT PANEL to retain the original size from Excel.

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 (Excel 2016 requires cell background colors and borders to be distinct). 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.