How to delete Excel Rows based on a value in c# interop

You can install Free Spire.XLS via nuget (https://www.nuget.org/packages/FreeSpire.XLS/), and then use it to find value and then delete the rows that contain the value with ease.

using Spire.Xls;

namespace DeleteRows
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook workbook = new Workbook();
            //Load the Excel file
            workbook.LoadFromFile("Input.xlsx");

            //Get the first worksheet
            Worksheet sheet = workbook.Worksheets[0];

            //Find text in the worksheet
            CellRange[] ranges = sheet.FindAllString("01", true, true);

            //Find text in a specific cell range
            //CellRange[] ranges = sheet.Range[2, 1, sheet.LastRow, 9].FindAllString("01", true, true);

            //Delete rows that contain the text
            for (int i = ranges.Length - 1; i >= 0; i--)
            {
                sheet.DeleteRow(ranges[i].Row);
            }

            //Save the file
            workbook.SaveToFile("DeleteRowsWithSpecificValue.xlsx", ExcelVersion.Version2013);
        }
    }
}