Skip to main content

Is it possible to delete rows in Excel based on a cell value?

 

I am comparing a data-set in Excel to another Excel file using Feature Merger. I want to delete the rows in the data-set which match a specific field (DETECTOR) in the new file(s).imageI feel like this should be very basic since Power Automate can do it (And MS has a surprisingly poor integration with their own software). The closest thing I found was the Database Deleter, but it doesn't have an Excel option for format. I can add Microsoft Excel as a new custom format, but that doesn't behave the way I would expect (opens a new workspace?).

You can just use the Excel (Feature)Writer to do this.

  • Expose xlsx_row_id using the AttributeExposer.
  • Use the FeatureWriter Excel writer.
    • Set Overwrite Existing File to No
    • Set Writer Mode to Delete

Thank you for your response! It seems I'm still missing something though.

 

When I run my workbench now, I can find the entry I need to delete:imageBut when it executes, the FeatureWriter only deletes the first row (red is the deleted row, purple is the row that should be deleted, and blue is the new row that was added):

image 


Reply