Have Questions?  Need Expert Answers?  JOIN LUNCH N' LEARNS!

Get Worksheet Count

  • Updated on Jul 9, 2025
  • Published on Nov 28, 2022
  • 1 minute(s) read
Prev Next

Overview

Step Details

Introduced in Version5.0.0
Last Modified in Version7.12.0
LocationData > 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

PropertyDescriptionData Type
File TypeThe type of file being used by the step.
CsvFileType
Input The Excel file to pull the data from.
FileData

Outputs

PropertyDescriptionData Type
GetWorksheetCount1_Output
The number of worksheets in the file.Int32

Related Forum Posts
Getting Values from an Excel File

Training Video:
Dynamic Excel Creation