How to delete filtered rows

Hello there!

I am trying to delete the filtered the rows in my excel file using the following steps:

However, all the contents in the sheet are being deleted. I am using the Use Excel File activity. Storing the data in a data table then using the Filter Wizard is not an option because I’m having a trouble with reading the whole workbook (throws an error or getting stuck because of massive data). So I’m trying to manipulate the data inside the Excel App.

Is there any way I can implement this?

Thank you!

@_pjflo

Before deleting please check if filter is getting applied properly…If the column formats are different sometimes filter does not work as expected

cheers

Thank you for your answer. Turned out, the activities are working as expected, it’s just that I didn’t clear the filters before performing succeeding activities.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.