Append Range (Workbook)
Adds a DataTable's rows below the last used row of a workbook file's sheet, without Use Excel File. Creates the file and the sheet when missing.
Behaviour
Risk: Low · Idempotent: No · Safe to retry: No · Recovery: Not replayed after a crash
Package Excel activities Velophex.Excel.Activities 0.7.1-rc.7 · Supported (Core profile) · type id velophex.excel.workbook.appendRange
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.
Data Table#
DataTable · DataTable · Required · Default: Not specified in package metadata
The rows to add.
Options#
Add Headers#
AddHeaders · Boolean · Optional · Default: False
Write the column names first when the sheet is empty.
Retry and risk#
This activity is not marked safe to retry: if it fails partway, check whether its work already happened before running it again. 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#
- Get Sheets
- 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, range, append, add, datatable, table, file.
Properties
Input
Options
Retry and risk
Related activities