How to select specified excel sheet


#1

Hi,

I’m trying to select the excel sheet identified in a string variable.
Though I used “select item” activity, but although it worked fine with
direct sheet name, using string variable which contains sheet name,
it throws exception…

How can I select specified excel sheet by a string variable which has
sheet name?

Best regards,
dekochan


#2

Hi @dekochan,

In the excel you have an option to navigate between sheets.
Type “Sheet3!A1” into Name box on the top right of the excel sheet.

Sheet_name!Cell_address

image


#3

Hi @dekochan

What exception did you encounter? Could you post a screenshot?


#4

Hi, SaranyaKishore,

Thanks for your information!! I could achive my expected behavior!!

Best regards,
dekochan


#5

Hi loginerror,

Since I’m dealing with secure system, I can’t share a screen shot, but
the exception content was like below.

Out of range exception

Thanks,
dekochan


#6

Welcome :slight_smile:
Mark it as solution if that solved your problem completeley.