get excel worksheet count
Retrieve the total number of worksheets that reside in the specified Excel workbook.
| Name | Description | Type | Modifier |
|---|---|---|---|
| file path | The location of the Excel file. | String | None |
| variable | (Optional) Variable to receive the returned value. | String | None |
Total number of worksheets (include hidden sheets) that reside in the specified Excel workbook.
This action may be used within the following project items: test modules and user-defined actions.
file path
open excel workbook D:\data.xlsx
 
file path variable
get excel worksheet count D:\data.xlsx count
 
file path auto save
close excel workbook D:\data.xlsx false
 
Result
- This action only supports Excel extensions: .xls, .xlsx, .xlsm.
- You need to use built-in action open excel workbook before proceeding with this action.
Tel:
Email: