How to select specified excel sheet

Help
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

2 Likes
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

1 Like
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.