How to count the number of sheets in the excel file

excel
uiautomation
activities
studio

#1

Hi Guys,

How to count the number of sheets (sheet 1,sheet 2…sheet n) in the excel file.?
Please let me know your answers,

Thanks in Advance,


#2

you can use an assign with Wb.Sheets.Count


#3

Hi @TimK,

Tried the same,but no luck :frowning:


#4

if you can send me the sample files,that willbe great


#5

@rpadev please check attached file NextSheetExl.zip (85.3 KB)


How to read more than one excel sheets in a for each loop
#6

Hey…Thanks @indra .It works perfectly