Articles → UiPath → Get Workbook Sheet And Get Workbook Sheets Activities In Uipath

Get Workbook Sheet And Get Workbook Sheets Activities In Uipath

Purpose

1. Get Workbook Sheet - This activity returns the worksheet name based on the index of the worksheet.
2. Get Workbook Sheets - This activity returns the name of all worksheets in a given workbook.

Example

1. Drag and drop the "Get Workbook Sheet" activity.
2. Set the output of the activity to the "strWorkSheetName" variable.
3. Drag and drop the "Get Workbook Sheets" activity.
4. Set the output of the activity to the "allWorkSheets" variable.
5. Write the value of "strWorkSheetName" and "allWorkSheets" variable in the text file.


Click to Enlarge

Output