EASA Help Pages

User Tools

Site Tools

You are here: EASA 6.1 » Author Guide » Tree Objects » WRITE EXCEL ACTION

Sidebar

About EASA | Contact

Contents

Table of Contents

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 cells
  • Named ranges as specified in Ranges:
  • Specified NAMED RANGEs for a specific spreadsheet in Sheets:
    …then requires a CELL REFRESH to update the spreadsheet with data from the EASAP

Ranges: 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.)

To efficiently see updated cell values in an EASAP:

  1. Set SPREADSHEET > Global Dependencies: TRUE
  2. Call a CELL REFRESH with Objects: [one or more WRITE EXCEL ACTION(s)]

Cell Reference

To specify a cell reference in Ranges: w it one of these two formats:

  • 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 LISTs. 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 may be specified in Ranges: by comma-separating the individual cell reference's or NAMED RANGE values. Therefore, a single WRITE EXCEL ACTION may populate the cells within multiple spreadsheets with values from existing SCALARs or LISTs.

All four parameters below must be completed with the same number of NAMED RANGE or cell reference entries:

  • Ranges:
  • Sheets:
  • Types:
  • Lists:

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 one or more sheets from list of available SHEET objects as data destinations
Ranges:Comma-separated list of NAMED RANGEs or cell references to write into (eg. start_cell:end_cell such as B6:G6 or single cell single_cell such as A4)
The cell type of the first value of a range will determine the cell type for the entire range
Types:Select type of write for each range specified (COLUMN, NORMAL RANGE, ROW)
Lists:Select existing LISTs to write into spreadsheets
Optional Parameters:
Delimiter:Character to delimit object references in Ranges: (Default: % )
Do if:Logical expression, if true then action is performed and not otherwise (Default: true)
Checking: Turn off the EASAP 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 (Default: TRUE)

Page Tools