Count unhide rows

how to count un hide rows, with uipath?

1 Like

Fine
–use excel application scope and pass the file path as input
–use read range activity and get the output with a variable of tye datatable named dt
–now use write line activity and mention like this
dt.Rows.Count.ToString
this will give us the count of no. of rows which are not hidden

Cheers @shashank

no mate, with this step it will give hidden rows as well , i want only unhidden rows.

1 Like

aahh, fine i though we need to include them as well
sorry for that
i hope we wont be able to read them with the activities in EXCEL package
Kindly try with workbook activities of READ RANGE and try once

Cheers @shashank

i tried with as well, actually the scenario is this, i’m putting filter in excel by running macro. and after that i’m getting the desired output by fetching the row count value but the problem is that when i’m trying to use dt.Rows.Count.ToString this function it will give hidden rows as well. that’s why i want only unhidden rows.