An Excel Desktop Client EASAP offers a novel way to use Microsoft Excel to create and modify database case records.
Via their browser, a User will:
In the steps below we walk through this process in detail. Browsers tend to behave differently with downloading and opening files from the network and system security settings vary as well. If you get stuck please contact EASA Technical Services (email@example.com).
1. Open a published EDC EASAP. For this example download, import and open MortgageCalculatorEDC.easap
2. Click on an existing case in the CASE VIEWER table and click 'Modify' or click 'New'
The browser will either automatically download an Excel spreadsheet (edc.xlsm) or else prompt us to download one, if its missing check if any popups have been blocked.
Chrome simplifies the steps above:
If Excel asks if you want to 'Enable Editing' click 'Yes'
3. The first time an Excel Client EASAP is run by a User the EASA Ribbon will need to be installed.
Click: Open Spreadsheet
4. A temporary Excel spreadsheet or 'Excel Client' will open.
A User may interact with the spreadsheet in familiar ways, a change in an input cell causes output cells and charts to be updated.
5. Once the User has completed an analysis the case record (a full or a partial set of named ranges) may be written to the database. On the EASA ribbon click: EASA > Save
6. Close the spreadsheet window, the updated case record may be viewed in the CASE VIEWER table.
Steps 1. – 6. may be repeated to create new cases or update existing case records.
An Author may now wish to read on and implement an EDC EASAP for his or her own spreadsheet, see Author a simple Excel Client/EDC EASAP