User Tools

Site Tools


Guide Section: Interacting With Excel Spreadsheets | EASAP Tree: SPREADSHEET LISTSPREADSHEET

NAMED RANGE's are created automatically by the EASAP Builder by reading them directly from spreadsheet files specified within a SPREADSHEET.

Authors are encouraged to create Excel NAMED RANGES within the spreadsheet in order to give an EASAP an explicit way to access Excel cells.

NAMED RANGE's can be used within Range Reference: parameters of data entry objects (INPUTBOX, CHOICE LIST, etc.) and Ranges: parameters of Excel actions (READ EXCEL ACTION, WRITE EXCEL ACTION, etc.).

A NAMED RANGE can specify additional information; for example, when a dimension is needed via the Unit: parameter or when overriding the cell type using the Cell Type: parameter.

Essential Parameters:
Name:Select a NAMED RANGE from a list, the NAMED RANGE object name should be identical to this name.
Optional Parameters:
Dependents:Comma-separated list of cells dependent on this referenced cell. Set automatically by dependency calculation, an Author may not change these, but instead may specify Additional Dependents: (below).
Additional Dependents:Comma-separated list of dependent cells that the dependency algorithm has failed to include. ( [1!A5] → Cell A5 in Sheet 1)
Unit:Select unit of value stored in cell. Should be set when value in cell is NOT in the base unit used in EASAP for this value.
Cell Type:Set whether the cell is an INPUT or OUTPUT, or BOTH.
Address:The address of the named range in the spreadsheet, updated after each save.
Precedents:This parameter is populated when dependencies are calculated. When any of the listed cells are modified by an EXCEL WRITE ACTION, any user interface elements linked to this NAMED RANGE will be refreshed. The Author should not change this parameter.

Below is an example of a NAMED RANGE: