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