Delete a row in an Excel file based on cell content
In some scenarios where you will use an Excel file to store data temporarily during your experience, the data may have indexes different from the row number. Below is the process to delete a particular row based on the content of a cell. We will assume that the values in the column used are unique.
- Add a Filter on your collection so that the item you want to delete is the only one left.
- Delete Row number 1
- Clear the filter on the column you used to identify your item.