Read Range of the entire first sheet of each excel within a folder

Help StudioX
,
1

Hello - I am attempting to Read Range only the first sheet of each excel within a folder. However, each file may have a different name for the first sheet of each file (for example, one files first sheet might be named “Sheet 1” while another files first sheet might be named “distribution”). Does anyone have a suggestion on how to select only the first sheet of each excel file regardless of what the name of the sheet is?

2

Hi @audra.swope

To make the dynamic of first sheet of every file use for each excel sheet activity to get the first sheet name then use the break activity to break after first iteration.

Hope it helps!!

3

Thank you. would you be able to show me what that looks like in the workflow? I am new to this and physically seeing the activity helps me.

4

Okay @audra.swope

Check the below workflow for better understanding,
Sequence2.xaml (19.1 KB)

This image depicts a UiPath workflow designed to read an Excel file, iterate through each sheet, store the name of the first sheet, and display it in a message box. (Captioned by AI)
This image depicts a UiPath workflow designed to read an Excel file, iterate through each sheet, store the name of the first sheet, and display it in a message box. (Captioned by AI)877×1303 87.1 KB

Output -

The image displays a UiPath automation process that opens an Excel file and retrieves the name of the first sheet, displaying it in a message box. (Captioned by AI)
The image displays a UiPath automation process that opens an Excel file and retrieves the name of the first sheet, displaying it in a message box. (Captioned by AI)716×716 29.2 KB

Hope it helps!!