Read Column (Workbook)

Reads a column of a workbook file from a starting cell to the column's last used cell, without Use Excel File.

Behaviour

Risk: None · Idempotent: Yes · Safe to retry: Yes · Recovery: Replayed after a crash

Package Excel activities Velophex.Excel.Activities 0.7.1-rc.7 · Supported (Core profile) · type id velophex.excel.workbook.readColumn

Properties#

Input#

Workbook Path#

WorkbookPath · String · Required · Default: Not specified in package metadata

The .xlsx or .xlsm file. Relative paths resolve against the project folder.

Sheet#

Sheet · String · Required · Default: Sheet1

The name of the sheet.

Starting Cell#

StartingCell · String · Optional · Default: A1

The first cell of the column read. Defaults to A1.

Output#

Values#

Values · IReadOnlyList<Object> · Output

The cells' values, blank cells as null.

Retry and risk#

This activity is safe to retry: running it again after a transient failure does not repeat a side effect. If a run is interrupted and the outcome of a step is unknown, the step is never retried automatically (what to do). How activities declare this: characteristics, retries and risk.

Every activity also has the engine's common properties: Timeout and Continue On Error.

Related activities#

• Append Range (Workbook)
• Get Sheets
• Get Table Range
• Read Cell (Workbook)
• Read Cell Formula
• Read Range (Workbook)
• Read Row (Workbook)
• Write Cell (Workbook)

Generated from Velophex.Excel.Activities 0.7.1-rc.7. Category: Workbook. Keywords: workbook, xlsx, spreadsheet, column, read, values, file.

Properties

Input

Output

Retry and risk

Related activities