Get row count of all worksheets

excel
activities
studio

#1

I have an Excel file which has new sheet names every week. I’d like to return the sheet name & also a count of all the rows in each sheet.
I can pick up the sheet names, but I can’t seem to use rows.count or any variation of that.

Has anyone got a solution?

Thanks!


#2

Hi ,
Can you please check this. It May help you.

File : Get row count of all worksheets.zip (9.5 KB)

Regards
Balamurugan.S


#3

Thank you!
Worked perfectly


#4

Nice … :slight_smile:


#5

Is there a way to write this to a file rather than a write line?
When i try, it seems to overwrite A1 in an Excel


#6

Yes, you can use write cell activity.

Regards
Balamurugan.S