How to delete filtered rows

Help Activities
,
1

Hello there!

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

image
image479×612 12.4 KB

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!

2

@_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

3

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.