Hide Excel rows base on condition

[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…