For Each Excel Or CSV Row Step
- 24 Apr 2024
- 1 Minute to read
- Print
- DarkLight
For Each Excel Or CSV Row Step
- Updated on 24 Apr 2024
- 1 Minute to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Step Details | |
| Introduced in Version | --- |
| Last Modified in Version | 7.12.0 |
| Location | Data > Excel & CSV |
The For Each Excel Or CSV Row Step can be used to create a Flow loop to perform the same actions for every row within an excel or CSV row within a list from the "Next" outcome. The "Done" outcome is used when all of the items in a list have been processed.
When selecting the Input File Type under the INPUT DATA section, be mindful of what type of file is being used. CSV, XLS, and XLSX files all have specific properties and limitations. For instance, XLS files only support 65,536 rows.
Properties
Inputs
| Property | Description | Data Type |
|---|---|---|
| File Input | The CSV or Excel file that is used as input. | FileData |
| Worksheet Number | Determines which worksheet that will be edited. |
Input Data
| Property | Description | Data Type |
|---|---|---|
| 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. | --- |
| Worksheet Number | Determines which worksheet that will be evaluated. | Int32 |
| Ignore First Row | Ignores the first line of the worksheet often used as headers in Excel files. | Boolean |
| Get Worksheet From Flow | Enabling this Property allows users to dynamically set the Worksheet Number within Inputs. | |
| Ignore Empty Rows | Ignores any rows that do not contain any data. | Boolean |
| CSV Delimiter | Determines which delimiter will be added with the values for CSV files. | --- |
Outputs
| Property | Description | Data Type |
|---|---|---|
| Next Row | Outputs a single row of DynamicDataRow to use to manipulate data. | DynamicDataRow |
Common Errors
Wrong File Type
Under INPUT DATA, the Input File Type selection must match the file that is being used by the step. An XLSX file must use the Excel_xlsx setting. The step may function incorrectly otherwise.
Feature Change
| Description | Version | Developer Task |
|---|---|---|
| Fixed a bug that prevented values from being displayed correctly if they were formatted, for instance as currency or decimals. | 8.19 | DT-040248 |
Related Information
Forum Posts:
Using 'CSV To List Mapping' Step
Was this article helpful?
