Read range workbook

Hello everyone,
We have a question for our projects. I need to open excel file in background without the name sheet. We use activity “read range workbook”.
Attach picture.
Thanks
BlankProcess8 - UiPath Studio Community

Could you elaborate? @Rodriguez

1 Like

Yes, the thing is: we need to read the first sheet by taking the index, for example. Same thing as in excel application scope but working in the background. So we dont need to know the sheet´s name cause it may change

@Rodriguez
Please see if this helps: Read 1st sheet of all the excels

Regards

Hi,

There is a sample for getting active sheet name without using Excel in the following post. This might help you.

Regards,

Hi @Rodriguez

Welcome to the community!

Attaching here the workflow for fetching the Sheet names for an excel. after fetchning the names you can use the same which ever is required as your input sheet. or as an index value. Just change the excel path.

thanks
Biswajeet
FindingSheetnName.xaml (6.1 KB)

Thank you @Yoichi
This works