- Excel Desktop Client new !
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.
EASA does not support spreadsheets with macros that move or delete cells.
|CLEAR EXCEL RANGE|
|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)|
|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|
When specifying a cell reference in the Ranges: parameter, the format of the range takes one of the following two forms:
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.
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.