Hi can any one help me, I want to delete rows after I apply filter to one column, with out changing the header Names.
For our community to assist you, it is always best to provide a sample of an input and output file (either in text or as attachments).
Hi , May be below idea will help you,
Add/delete row activity directly work on excel when it is open(Under excel application scope)
Use Read range to read the sheet (datatable output dt)
filter the data as per your need using filter datatable activity or select query.(newFilterdt)
Under excel application scope and use delete row activity and delete all rows(no. of rows=dt.rows.count)
write range (newfilterdt) to paste the filter data table into excel.
above solution can give you head start. Hope you can find more effective way to achieve the same