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”.
Could you elaborate? @Rodriguez
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
There is a sample for getting active sheet name without using Excel in the following post. This might help you.
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.
FindingSheetnName.xaml (6.1 KB)
Thank you @Yoichi