Delete rows based on a column value from an excel having huge data
In an excel with more than 80K rows, I need to delete the rows which have specific text (e.g. #N/A) in a specific column. Using collections is not optimal, are there any other means to do this?