how to count un hide rows, with uipath?
–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
this will give us the count of no. of rows which are not hidden
no mate, with this step it will give hidden rows as well , i want only unhidden rows.
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
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.