Get Table Range
Returns the range of a named Excel table in a workbook file, for example A1:C10, 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.getTableRange
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 · Optional · Default: Not specified in package metadata
The sheet that holds the table. Empty searches every sheet.
Table Name#
TableName · String · Required · Default: Not specified in package metadata
The name of the Excel table.
Output#
Range#
Range · String · Output
The table's range in A1 notation, headers included.
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
- Read Cell (Workbook)
- Read Cell Formula
- Read Column (Workbook)
- 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, table, listobject, range, address, file.
Properties
Input
Output
Retry and risk
Related activities