WRITE EXCEL ACTION is used to write data from existing objects selected in the Lists: parameter into cell or named ranges as specified in the Ranges: parameter in Excel spreadsheets by referencing existing SHEET objects or specifying ‘Named Range’ for a specific spreadsheet in the Sheets: parameter. The Ranges: parameter is used in conjunction with the Types: parameter to determine how the object data is written into the specified spreadsheets. Cell References There are two methods for specifying the range to read:
When specifying a cell reference in the Ranges: parameter, the format of the range takes one of the following two forms:
The first format should be used together with a selection of ‘Normal Range’ in the Types: parameter, while the second format should be used with the ‘Row’ or ‘Column’ selections in the Types: parameter.
Note: Use ‘Row’ or ‘Column’ selections in the Types: parameter, when writing variable length LIST's. Data will be written along the row or column from the specified start cell in the Ranges: parameter until all the list values have been written.
More than one cell reference or named range can be specified in the Ranges: parameter by comma separating the individual cell reference or named range values. Therefore, a single WRITE EXCEL ACTION object can populate the cells within multiple spreadsheets with values from existing scalar or list objects.
Note: For every cell reference or named range specified in the Ranges: parameter, a corresponding value must be specified in each of the Sheets:, Types: and Lists: parameters, so that all four parameters contain the same number of entries.
Additionally, each range specified must have all their corresponding cells set to the same data type format, i.e. if the first cell in a range is of the type 'Short Date' then all the cells must have the same format too.
|WRITE EXCEL ACTION|
|Sheets:||Select sheets from list of available SHEET objects as data destinations|
|Ranges:||Comma-separated list of named or cell ranges to write into
(eg. start_cell:end_cell→B6:G6 or single cell single_cell→A4)
|Types:||Select type of write for each range specified (COLUMN, NORMAL RANGE, ROW)|
|Lists:||Select existing LIST objects to write into spreadsheets|
|Delimiter:||Character to act as delimiter in DORs in Ranges: parameter. default→%.|
|Do if:||Logical expression, if 'FALSE' then action NOT performed, otherwise 'TRUE'.|
|Checking:||Turn off the Builder's rules checking (default→STRICT or LENIENT)|
|WRITE EXCEL ACTION (PROCESSES Branch only)|
|Queue:||Set to TRUE to avoid running out of of free Excel processes|