Clear Range Workbook (preview)

Clear Range Workbook activity that clears the contents, and optionally the formatting, of a range without moving any cells.

UiPath.Excel.Activities.ClearRange

Beschreibung

Clears the contents, and optionally the formatting, of a range without moving any cells. This is the cross-platform equivalent of the Clear Sheet/Range/Table Windows activity.

Hinweis:

This activity does not support .xls files.

Projektkompatibilität

Windows | Plattformübergreifend

Eigenschaften

Allgemein

• DisplayName - The name displayed for the activity in the Designer panel.

Eingabe

• Datei – Der vollständige Pfad der Ressourcenarbeitsmappe. Um zu einem lokalen Pfad zu wechseln, wählen Sie das Plus-Symbol und dann Lokale Datei verwenden aus. Das aktuelle Feld ändert sich zu Datei (lokaler Pfad), wo Sie den vollständigen Pfad der Arbeitsmappe angeben können.
• Blattname – Der Name des Blatts aus der Arbeitsmappe.
• Range - The range to clear. This field is required.

Optionen

• Has headers - Select this option if the first row of the range is a header row. The header row is not cleared. A range that has a single row is left as it is. By default, this option is not selected.
• Clear Formatting - Select this option to clear the formatting of the range as well as its contents. By default, this option is selected, as in the Windows activity.
• Kennwort – Das Kennwort der Arbeitsmappe, falls erforderlich

Verwenden der Arbeitsmappe

• Workbook - The existing workbook to use instead of a file path.

Hinweise

• Cells outside the range are never moved. The activity only clears what is inside the range.
• When Has headers is selected, the header row is the first row of the range, or of the used range when you use a whole-column address.
• A whole-column or whole-row range, such as A:A, is limited to the used range of the sheet.
• Range must refer to the sheet in SheetName. A range that includes a sheet name, such as Sheet2!A1:A10, is not supported and causes an error.