How to select the 2nd sheet of an excel file regardless of name

Help Studio
, ,
2

@angelico_mdc,

Use Get Workbook Sheets activity. It’s a classic activity. It will give you array of string which will hold all sheet names.

Using array index 1 you can get second sheet.

Sample Code:

This image shows a UiPath workflow for processing an Excel file, including steps to open the file, retrieve workbook sheets, and log a message with the name of the first sheet. (Captioned by AI)
This image shows a UiPath workflow for processing an Excel file, including steps to open the file, retrieve workbook sheets, and log a message with the name of the first sheet. (Captioned by AI)939×1198 33.6 KB

Main.xaml (16.9 KB)

1 Like