Overview
Step Details | |
| Introduced in Version | 5.0.0 |
| Last Modified in Version | 5.0.0 |
| Location | Data > Excel and CSV |
The Get Line Count step outputs a count of the total number of used lines in an Excel/CSV file.
Properties
Inputs
| Property | Description | Data Type |
|---|---|---|
| File Type | The type of file being used by the step | CsvFileType |
| Ignore First Row | Ignores the first row in the file | Boolean |
| Input | The Excel or CSV file to pull the data from | FileData |
| Worksheet Number | The Worksheet Number to get the line count from. The worksheet number starts at 1. | Int32 |
Outputs
| Property | Description | Data Type | ||
|---|---|---|---|---|
| Output | Returns the total number of lines in the file | Int32 | ||
Related Forum Posts
Training Video:
Dynamic Excel Creation