User Tools

Site Tools


Guide Section: EDC → Excel Desktop Client | EASAP Tree: EVENT PROCESSINGACTION

DATABASE TO EXCEL DESKTOP launches an Excel Client from an EASAP.

DATABASE TO EXCEL DESKTOP may initialize named ranges in the spreadsheet with values from an EASAP.

The parameters an Author must configure depend on the value of the Action: parameter.

Use Initialize Named Ranges: and Initialization Data: to Implement locked-mode for an Excel Client spreadsheet.

Essential Parameters:
Action: New → starts an Excel Client with a blank spreadsheet to create a new case
Open → the currently selected case ID—the value of a CASE VIEWER object—in the Excel Client interface
Clone → copies a case record in the database, INSERT's it back into the database with a new case ID
Upgrade → opens a new spreadsheet (or spreadsheet 'version') with current case data. If the new spreadsheet contains a new named range, the old case records will be updated with the new named range and will have the string value NO VALUE. Once the case record is opened via an Upgrade the cells will have the Excel <BLANK> or empty value unless the named range has a default value.
Case Id:A CASE VIEWER or other SCALAR reference representing the case ID to open in an Excel Client.
(required for Action:→Open, Clone)
New Case Id:A SCALAR reference here will be updated with the new case ID
Optional Parameters:
Initialize Named Ranges:Select one or more NAMED RANGE's to initialize with Initialization Data:
Initialization Data:Select a SCALAR for each single-cell NAMED RANGE or a LIST for each multi-cell NAMED RANGE in Initialize Named Ranges:, Excel writes a two dimensional range of cells in rows from left to right, then top to bottom.
Data Separator:For data (often text) where a comma is a valid character, set an alternate character or string to separate elements in a LIST.

Page Tools