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|
|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)|
|Delimiter:||Set a character to delimit object references in Ranges:
|Do if:||Enter a logical expression, when true the action is performed and not otherwise
|CLEAR EXCEL RANGE (PROCESSES branch only)|
|On Error:|| Set whether any subsequent PROCESS or ACTION should STOP or CONTINUE after an error
|Queue:||Set to true to avoid running out of of free Excel processes (which generates an exception)|
To specify a cell reference in Ranges: use one of the following formats:
The first or second format is valid for: Types: Normal Range
Only the second format is valid for: Types: Row or Column
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.