How to get Excel Sheet name?

Hi,
I face a scenario where I am reading an excel file which has sheet name as “Sheet2” . But this Sheet name could change going forward. So, While reading a file using “Read Range” activity, How to pass the “Sheetname” which is currently available in the file rather than hardcoding it?

Thanks in Advance

Hi @esakkiappan.b ,

We could get all sheet names of a Workbook using the Get WorkBook Sheets Activity :

image

Could you try this and let us know if you are able to get the Sheet name as required.

Hi,
Thanks. I used “get workbook Sheet” activity . yes I could able to get it by passing the index of the sheet and an output variable to get the sheet name.

So, We could specific sheetnames using “get workbook Sheet” and all sheetnames in an excel using “get workbook Sheets” acitvity

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.