Convert Excel or CSV to Dynamic Data Rows

Updated on 20 Oct 2022
1 Minute to read

Print
Share
Dark

Light

Article Summary

Share feedback

Thanks for sharing your feedback!

Step Details
Introduced in Version	7.6.0
Last Modified in Version	7.12.0
Location	Data > Excel & CSV

As an addition to the host of CSV/Excel handling steps, users are provided the option to convert a user-defined Excel File or set of CSV into a List of Dynamic Data Rows using a single step. This allows the ability to use the Output Data values within Decisions.

Properties

Inputs

Property	Description	Data Type
Input File	The CSV or excel file that is used as input.	FileData
Worksheet Numer	Determines which worksheet that will be evaluated.	Int32

Input Data

Property	Description
Input File Type	Defines the type of file used as an input to the step. Currently, the options are Csv, Excel_xls, Excel_xlsx and AutoSelect	---
Ignore First Row	Ignores the first row in the Excel or CSV file, typically used as a header row.	Boolean
Get Worksheet From Flow	Enabling this Property allows users to dynamically set the Worksheet Number within Inputs.	Boolean
Worksheet Index	Determines which worksheet that will be evaluated.	Int32
CSV Delimiter	Determines which delimiter is used in the CSV files.	---