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 running on an Excel Server.

Initiate the Excel Wizard by either:

  • Create a new EASAP and select: New Application Wizard
  • Open an existing EASAP in the EASAP Builder and click: Tools > Excel Range Wizard (2.0)
  1. In 'New Application Wizard' select: Use Excel Range Wizard (2.0)
  2. Click: Finish
    …The following screen opens,

  3. Click: Choose File
  4. Select the tutorial Excel file: Mortgage Calculator.xls
  5. Click: Next
    …On the 'Select Excel Ranges' screen, we may 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.
  6. Click: Add a Range from Excel ( Add Range )
  7. Mortgage Calculator.xls file will open in Excel,
    Select cells 'A1' through 'G23' (click and drag to highlight these cells)
  8. Click: Finish to process our selections and exit the Excel Range Wizard
    …The EASAP Builder window will appear and the EASAP Tree will be populated with new objects created by the wizard.
  9. Let's save our work by clicking: Save** ( Save )
    …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.

Advanced Excel Range Wizard

The Excel Range Wizard (2.0) has some advanced options and a reference page, Advanced Use of Excel Range Wizard 2.0

This flowchart shows the cell categorization process.