User Tools

Site Tools


CLEAR EXCEL RANGE

Guide Section: Processing Events and Performing Actions
EASAP Tree: EVENT PROCESSINGACTION / PROCESSES


CLEAR EXCEL RANGE clears values in cells or NAMED RANGES's as specified in the Ranges: parameter in Excel spreadsheets by referencing existing SHEET's or specifying a 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 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 sheets from list of available Sheet object as data destinations
Ranges:Comma-separated list of named or Cell Reference's to write into (eg. B6:G6 or A4)
Optional Parameters:
Delimiter:Character to delimit object references in Ranges: parameter. default→%.
On Error:Specifies if the ACTION should continue or stop when an error occurs.
Do if:Logical expression, if FALSE then action NOT performed else default→TRUE.
CLEAR EXCEL RANGE (PROCESSES Branch only)
Queue:Set to TRUE to avoid running out of of free Excel processes

Ranges:

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 or second format can be used in conjunction with a selection of ‘Normal Range’ in the Types: parameter, while only the second format should be used with the ‘Row’ or ‘Column’ selections in the Types: parameter.

Multiple Ranges

More than one Cell Reference or NAMED RANGE can be specified in the Ranges: parameter by comma separating the values. Therefore, a single CLEAR EXCEL RANGE can 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.