Read Cell Formula

Reads the formula of one cell of a workbook file, without Use Excel File. Empty when the cell holds no formula.

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.readCellFormula

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.

Cell#

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

The cell in A1 notation.

Output#

Formula#

Formula · String · Output

The formula without the leading =, or empty.

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 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, cell, formula, read, get, file.

Properties

Input

Output

Retry and risk

Related activities