get excel worksheet property
Retrieve the Excel worksheet property.
| Name | Description | Type | Modifier |
|---|---|---|---|
| file path | The location of the Excel file. | String | None |
| sheet | Name or index of the sheet within the Excel file where the action will be performed. (Index starts at 1) | String | None |
| property | Worksheet property to be retrieved. Allowable values:
| Value Set | first used column, first used row, used rows, used columns, name |
| variable | (Optional) Variable to receive the returned value. | String | None |
Value of specified property from an Excel worksheet
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 sheet property variable
get excel worksheet property D:\data.xlsx Car Orders Data used rows total_row
 
file path sheet property variable
get excel worksheet property D:\data.xlsx Car Orders Data used columns total_column
 
file path sheet property variable
get excel worksheet property D:\data.xlsx Car Orders Data first used row first_used_row
 
file path sheet property variable
get excel worksheet property D:\data.xlsx Car Orders Data first used column first_used_column
 
file path sheet property variable
get excel worksheet property D:\data.xlsx 1 name sheet_name
 
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.
- sheet argument:
- If a sheet name has the value as a numerical text (e.g. the sheet name is 7), enclose the value in quotation marks to differentiate it from a numerical index value (e.g. "7").
Tel:
Email: