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

Ключ

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

...

Action shows hidden columns in Excel file

Action icon

Action parameters

Input parameters

  1. "Context" field - The context of the action for working with the Excel document.
  2. "Starting column name" field - The name of the starting column in the range that will be shown. If the specified column is not hidden, the action will display a warning. It will not terminate with an error. If the field is not filled in, the value from the "Starting column index" field is taken.
  3. "Starting column index" field - The index of the starting column in the range to be displayed. If the specified column is not hidden, the action will display a warning. It will not terminate with an error.
  4. "Final column name" field - The name of the final column in the range to be shown. If the field is not filled in, the value from the "Final column index" field is taken.
  5. "Final column index" field - The index of the final column in the range that will be shown. If the field is not filled in, one column will be hidden.

...

Settings of parameters

Property

Description

Type

Example of filling in

Obligatory to fill in the field

Parameters

Context

Action context for working with an Excel document

Excel instance

Excel context

Yes

Starting column name

The name of the starting column in the range to be displayed. If the specified column is not hidden, the action will display a warning. It will not terminate with an error. If the field is not filled in, the value from the "Starting column index" field is taken.

String


No

Starting column index

The index of the starting column in the range to be displayed. If the specified column is not hidden, the action will display a warning. It will not terminate with an error.

Numeric


No

Final column name

The name of the end column in the range to be displayed. If the field is not filled in, the value from the "Final column index" field is taken.

String


No

Final column index

The index of the final column in the range to be shown. If the field is not filled in, a single column will be shown.

Numeric


No

...