Homepage | About EASA | Contact
Sidebar
WRITE EXCEL ACTION
Guide Section: Processing Events and Performing Actions | EASAP Tree: EVENT PROCESSING → ACTION / PROCESSES
WRITE EXCEL ACTION writes data from objects selected in Lists: into Excel cell or named ranges as specified in Ranges: and on a SHEET or specifying ‘Named Range’ for a specific spreadsheet in Sheets:. The Ranges: parameter is used in conjunction with Types: to determine how data is written into the specified spreadsheets. There are two methods for specifying the range to read:
WRITE EXCEL ACTION may fail on spreadsheets with macros that move or delete cells, these spreadsheets need to be modified (either change any macros that move or delete cells or create a custom sheet with non-moved/deleted cells that refer to the moved/deleted cells.)
Cell Reference
When specifying a Cell Reference in the Ranges: parameter, the format of the range takes one of the following two forms:
- start_cell:end_cell (eg: A5:A25 )
- start_cell (eg: A5 )
The first format should be used together by selecting ‘Normal Range’ in Types:, while the second format should be used with the ‘Row’ or ‘Column’ selections in Types:.
Use ‘Row’ or ‘Column’ selections in Types:, when writing variable length LIST's. Data will be written along the row or column from the specified start cell in Ranges: until all the list values have been written.
Multiple Ranges
More than one Cell Reference or NAMED RANGE can be specified in Ranges: by comma-separating the individual cell reference's or NAMED RANGE values. Therefore, a single WRITE EXCEL ACTION can populate the cells within multiple spreadsheets with values from existing SCALAR's or LIST's.
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. Thus if the first cell in a range is of the type 'Short Date' then all the cells must have the same format too.
Dates
Excel dates are handled as numeric data. Prior to writing to Excel, please use DATE CONVERSION on the DATA PROCESSING branch to convert DATEBOX data into the appropriate Excel format.
 WRITE EXCEL ACTION |
|
|---|---|
| Essential Parameters: | |
| Sheets: | Select sheets from list of available SHEET objects as data destinations |
| Ranges: | Comma-separated list of NAMED RANGE's or cell references 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's to write into spreadsheets |
| Optional Parameters: | |
| Delimiter: | Character to delimit object references 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 |