Query on how to assign a variable to getsheet

[RIA_SAHA_D_O_RATAN_SAHA_S (helpp)]

hi, i want my variable (count) to calculate how many excel sheets there are in my sheet and for that i wish to use the function; GetSheet on my variable expression, but i am not able to do so.

[ptrobot]

Have you tried the activity Get Workbook Sheets instead?

[Anil_G (Anil Gorthi)]

Hi @RIA_SAHA_D_O_RATAN_SAHA_S

Welcome to the community

Use Get Workbook sheet and take the count wbsh.Count

Here wbsh is the output from Get workbook sheets

cheers

[Yoichi]

Hi,

Hope the following helps you.

count = wkb.GetSheets().Count()

Regards,