Hide Excel rows base on condition

[Katrina]

Hi, I want do hide the rows if column A contains #N/A (i.e. A4,A5,A7,A8). Can someone help me with this? Thank you.

[fernando_zuluaga]

hi @Katrina

please refer from this post

How to hide Rows that has no value?

Thank you, but not working for me. Can you please test the attached excel file? I just want to hide the rows that have “0” in column “Amount”(G). test.xlsx (14.9 KB)

best regards!

[Katrina]

Thank you for your suggestion. But for my case, how should I amend the expression?

[fernando_zuluaga]

(From idx In Enumerable.Range(0,dtData.Rows.Count)
Where dtData.Rows(idx)(YourColumnNameOrIndex).toString.Trim.StartsWith(YourFilterString)
Select idx + YourOffset).toArray

here you got the template, are your replacing all the values from your values? like column name, you dt variable, filter

and remember after that to get youroffset which is explained here

How to hide Rows that has no value?

@Akash_Chavan we can do it with the help of: [grafik] the data has some offset (does mean, the datatable ommits some excel rows) and we define a variable for this: [grafik] then following flow is calculating the row indexes which are to hide and pass this information to the balareva activity [grafik] Calculation of the indexes can be done with following: (From idx In Enumerable.Range(0,dtData.Rows.Count) Where dtData.Rows(idx)(2).toString.Trim.StartsWith("-") Select idx + Offset).t…

[Katrina]

I have tried to amend it, but it doesnt work. Actually my excel has a filter but there is no table. I used the read cell activity instead of read range and I got an error of (Object reference not set to an instnace of an object). Is there any way to solve it? Thank you.