Articles → UiPath → Get Workbook Sheet And Get Workbook Sheets Activities In Uipath
Get Workbook Sheet And Get Workbook Sheets Activities In Uipath
Purpose
- Get Workbook Sheet - This activity returns the worksheet name based on the index of the worksheet.
- Get Workbook Sheets - This activity returns the name of all worksheets in a given workbook.
Example
- Drag and drop the "Get Workbook Sheet" activity.
- Set the output of the activity to the "strWorkSheetName" variable.
- Drag and drop the "Get Workbook Sheets" activity.
- Set the output of the activity to the "allWorkSheets" variable.
- Write the value of "strWorkSheetName" and "allWorkSheets" variable in the text file.
Click to Enlarge
Output
Click to Enlarge