Read CSV

Reads a CSV or delimited text file into a DataTable.

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

Properties#

Input#

File Path#

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

Path to the CSV file.

Options#

Delimiter#

Delimiter · String · Optional · Default: ,

Column delimiter (e.g. ',' or ';'). Defaults to ','.

Has Headers#

HasHeaders · Boolean · Optional · Default: True

True if the first row contains column headers.

Encoding#

EncodingName · String · Optional · Default: utf-8

Character encoding (e.g. 'utf-8', 'ascii'). Defaults to UTF-8.

Output#

Data Table#

DataTable · DataTable · Output

The resulting DataTable with the CSV data.

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.

Generated from Velophex.Excel.Activities 0.7.1-rc.7. Category: CSV. Keywords: csv, text, delimited, read, datatable, table.

Properties

Input

Options

Output

Retry and risk

Related activities