Dynamic sheet read in workbook read range

Help Studio
1

hi all,
i have excels which contains sheet1,sheet,sheet3 etc. so i want to get dynamically sheet name and read the excel. But showstopper: i want to read only one sheet which contains data either its sheet1 or sheet2.
i tried excel scope
read range
Out_sheet_col=out_workbook.GetSheets
for each in item
but it will read all sheet which i don’t want. is there any way to get specific dynamic sheet

2

Hi sayali rokade,

if you are not confirm data is In which sheet
Then I think you have to go sheet by sheet the same way you are doing

Thanks

3

a sheet has a name.

So go with what you gat.
In your for each item loop build an if/then

if sheet.name (or item.name) = target sheet: read it.

4

ya but some sheets are black hence it will give an error in my flow for read range

5

ya but sheet are dynamic na .sometimes data is in sheet2 sometimes in sheet1 .what name should i gave.pls share sample if u have for better understanding

I tried ur if condition but showing name is not string member

6

Hi,

After reading workbook sheet name in for each use an if condition

item.rowcount=0

keep then part empty or continue in else part read range and break activity

or

use try catch inside for each in try block use read range and pass item
in catch block give continue