Sidebar
Table of Contents
CLEAR EXCEL RANGE
Guide Section: Processing Events and Performing Actions
EASAP Tree: EVENT PROCESSING > ACTION / PROCESSES
CLEAR EXCEL RANGE clears values in cells or NAMED RANGEs as specified in Ranges: for an Excel spreadsheet by referencing existing SHEETs or specifying a NAMED RANGE for a specific spreadsheet in Sheets:
Ranges: is used in conjunction with the Types: parameter to determine how the values are cleared in the specified spreadsheets.
The CELL REFRESH action followed by a MENU ACTION ‘Refresh’ is sometimes needed after running either a RUN MACRO ACTION or CLEAR EXCEL RANGE.
EASA does not support spreadsheets with macros that move or delete cells.
 CLEAR EXCEL RANGE |
|
|---|---|
| Essential Parameters: | |
| Sheets: | Select one or more sheets from list |
| Ranges: | Enter a comma-separated list of named or cell references to write into (eg. B6:G6 or A4) |
| Optional Parameters: | |
| Delimiter: | Set a character to delimit object references in Ranges: Default: % |
| Do if: | Enter a logical expression, when true the action is performed and not otherwise Default: true |
| CLEAR EXCEL RANGE (PROCESSES branch only) |
|
| On Error: | Set whether any subsequent PROCESS or ACTION should STOP or CONTINUE after an error Default: CONTINUE |
| Queue: | Set to true to avoid running out of of free Excel processes (which generates an exception) |
Ranges:
To specify a cell reference in Ranges: use one of the following formats:
- start_cell:end_cell (eg. A5:A25 )
- start_cell (eg. A5 )
The first or second format is valid for: Types: Normal Range
Only the second format is valid for: Types: Row or Column
Multiple Ranges
More than one cell reference or NAMED RANGE may be specified in the Ranges: parameter by comma separating the values.
Thus a single CLEAR EXCEL RANGE may clear the values from cells within multiple spreadsheets.
For every cell reference or NAMED RANGE specified in the Ranges: parameter, a corresponding value must be specified in each of the Sheets: and Types: parameters, so that all three parameters contain the same number of entries.