The Import Excel or CSV step takes in a CSV/Excel file and maps the desired columns to an Object List dynamically at runtime.
Properties
Error Handling
Property
Description
Data Type
Extra Columns in Input
Will provide an error if extra columns are found in the input (Add Outcome: provides an outcome path, Throw Exception will throw an exception on reaching error, Ignore and Continue: will add an outcome path and ignore the error.)
---
Less Columns in Input
Will provide an error if the columns found are less than expected (Add Outcome: provides an outcome path, Throw Exception will throw an exception on reaching error, Ignore and Continue: add an outcome path and ignore the error.)
---
Value Conversion Error
Will send an error if a value can not be converted (Add Outcome: provides an outcome path, Throw Exception will throw an exception on reaching error, Ignore and Continue: add an outcome path and ignore the error.)
