Need to filter data in excel sheet and and remove those rows in excel sheet.
I tried with filtering data table and pasting it in same sheet. But the existing formulas in the cells are getting removed.
Requirement is when apply filter in excel sheet formulas should not be removed.
Would someone please propose some ideas on this issue.
Read Range from Excel gets the values and not the formula, therefore you cannot write the formulars to the excel because you do not know them.
One option would be to use “Filter Table” activity with “Create Table” Activity before: Link to forum entry