Get Sheets

Lists the sheet names of a workbook file in workbook order, 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.getSheets

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.

Output#

Sheets#

Sheets · List<String> · Output

The sheet names in workbook order.

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 Table Range
• 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, sheets, worksheets, names, list, file.

Properties

Input

Output

Retry and risk

Related activities