Delete Columns Workbook (preview)

Delete Columns Workbook activity that deletes one or more consecutive columns from a sheet, starting at a specified column.

UiPath.Excel.Activities.DeleteColumns

Beschreibung

Deletes one or more consecutive columns from a sheet, starting at a specified column. This is the cross-platform equivalent of the Delete Column 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 that contains the column. When Has headers is selected, the first row of the range is the header row. If you use a column letter, it must be inside this range. If you don't specify a range, the used range of the sheet is used.
• Start Column - The column to start deleting from. Enter its header name when Has headers is selected, or its letter otherwise, for example, "B". This field is required.
• Number Of Columns - The number of columns to delete. The value must be greater than zero. The default value is 1.

Optionen

• Has headers - Select this option if the first row of the range is a header row. Start Column is then a header name. By default, this option is not selected.

  Hinweis:

  Unlike in the Windows Delete Column activity, Has headers is not selected by default.

• Kennwort – Das Kennwort der Arbeitsmappe, falls erforderlich

Verwenden der Arbeitsmappe

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

Hinweise

• The activity deletes entire sheet columns, not only the cells of the range. The range only shows where the headers are, or which column letters are valid.
• The columns after the deleted columns shift left to fill the gap.
• A header name that is not in the first row of the range, or a column letter outside the range, causes an error and nothing is deleted.

Bekannte Einschränkungen

Deleting columns of a table is not supported yet.