Once connections have been defined with one or more Excel spreadsheets, there are then two methods for exchanging data between the EASAP and these spreadsheets:
The following Child objects to a TABBED PANE contain a Range Reference: parameter.
The Range Reference parameter allows you to select from a list of available Named Ranges and RANGE REFERENCE objects. Once the Range Reference: parameter is specified, the data entry object will be automatically linked to the referenced cell in the Excel spreadsheet.
Note: Using the Range Reference parameter, you can only choose Named Ranges that link to one cell within an Excel spreadsheet. However, Named Ranges linking to more than one cell can be used with actions.
The behavior of the linkage between the cell and the data entry object depends on the cell is a Input or Output type.
Sometimes it will not make sense for you to directly reference cells in data entry objects; for instance, when a CHOICE LIST is used to retrieve input from a user, but the actual cell values come from a MAP derived from the user’s selection in the choice list. In these cases, special event and action objects designed to interact with Excel spreadsheets can be used to perform a variety of tasks:
A summary of the available Excel EVENT's and ACTION's is given in the table below. These EVENT's and ACTION's will be found within either EVENT PROCESSING objects in the USER INTERFACE branch or the PROCESSES branch.
|READ EXCEL ACTION||Reads values from specified cell ranges in Excel spreadsheets into specified list objects|
|WRITE EXCEL ACTION||Writes values from specified list objects into specified cell ranges in Excel spreadsheets|
|IMAGE EXCEL ACTION||Extracts a screen capture of cell range or chart in an Excel spreadsheet for display by an IMAGE in a DIAGRAM|
|GET EXCEL FILE ACTION||Gets the current copy of the Excel spreadsheet from the Excel Server. Allows an author to download it from the EASAP|
|RUN MACRO ACTION||Executes a macro in an Excel spreadsheet|
|CELL REFRESH||Refreshes data associated with RANGE REFERENCE objects either to or from an Excel spreadsheet|
|CLEAR EXCEL RANGE||Clears values from cells within specified ranges|