Get Worksheet Count
- 09 Nov 2023
- 1 Minute to read
- Print
- DarkLight
Get Worksheet Count
- Updated on 09 Nov 2023
- 1 Minute to read
- Print
- DarkLight
Article Summary
Share feedback
Thanks for sharing your feedback!
Overview
Step Details | |
| Introduced in Version | 5.0.0 |
| Last Modified in Version | 7.12.0 |
| Location | Data > Excel and CSV |
The step "Get Worksheet Count" returns the number of sheets as an int32 type for an Excel file defined in the input section.
Note: CSV file data is not supported with this step, as CSV cannot contain more than one worksheet.
Properties
Inputs
| Property | Description | Data Type |
|---|---|---|
| File Type | The type of file being used by the step. | CsvFileType |
| Input | The Excel file to pull the data from. | FileData |
Outputs
| Property | Description | Data Type |
|---|---|---|
| GetWorksheetCount1_Output | The number of worksheets in the file. | Int32 |
Related Forum Posts
Was this article helpful?
