Сравнение версий

Ключ

  • Эта строка добавлена.
  • Эта строка удалена.
  • Изменено форматирование.

Delete columns Version 1 (Python)

Action groups: Office

...

Description

Action deletes the specified columns

Action icon

Image RemovedImage Added

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for working with ods/xlsx table.Robin.OpenSheetD oc
Yes
Starting column nameThe name of the starting column in the range of columns to be deleted. If the field is not filled in, the starting column will be determined by the value from the «Starting column index» field. If neither the name nor the index of the starting column is specified, the action will fail.Robin.String
No
Starting column indexThe sequence number of the starting column in the range of columns to be deleted. The numbering starts from 1.Robin.Numeric
No
Ending column nameThe name of the ending column in the range of columns to be deleted. If the field is not filled in, the starting column will be determined by the value from the «Ending column index» field. If neither the name nor the Ending column index is specified, the range will be limited to the starting column only.Robin.String
No
Ending column indexThe sequence number of the ending column in the range of columns to be deleted. The numbering starts from 1.Robin.Numeric
No

Special conditions of use

None.

Example of use

Task

There is a tabular document. It is necessary to delete columns A, B, C.

Solution

Implementation of the action requires the following actions - "Open", "Delete columns", "Save".

Implementation

  1. Assemble a robot scheme consisting of actions:

...