User Tools

Site Tools


Excel Desktop Client Reference

Activate a spreadsheet for EDC

The objects below have specific roles in an Excel Client EASAP.

To make any of these objects active an Author must:

  • Upload a spreadsheet and
    • Add a SHEET under SPREADSHEET LIST
      • For this SHEET set:
        • File: (the spreadsheet filename)
        • Desktop: TRUE

Only recent Excel versions are supported

Please update to a more recent version if you are running an Excel version that is older than Excel 2010 14.0.7165.5000.


Add VBA to Capture Excel→Save and Excel→Close

To hide proprietary formulas and VBA from the User an Excel Client an Author should,


An imported Excel Client EASAP name must be unique

An imported Excel Client EASAP name will be incremented with an integer in parenthesis if one of the same name already exists.

Excel Client EASAP's cannot be deleted in the traditional sense as the data viewable in a CASE VIEWER is persistent by design.


Excel Named Ranges must not have the literal 'prop_' as a prefix

Due to some unfortunate internal behavior of Excel, any named range with a prefix prop_ in any combination of capital or lowercase letters will cause the complete loss of data integrity within that range.

For an Excel Client spreadsheet rename any named range with the prefix prop_ to my_prop_ or property_, etc…


Run DATABASE TO EXCEL DESKTOP without a CASE VIEWER

In order to download an Excel Client instance without using a CASE VIEWER add this javascript to the Label: of a LABEL.


Page Tools