Validating the Excel Data Fields with OpenXML Library

Alternatively, you can use Free Spire.XLS library to read and manipulate Excel files:

https://www.e-iceblue.com/Introduce/free-xls-component.html  (also available on nuget)

Here is a basic example for reading data from Excel:

            Workbook workbook = new Workbook();
            workbook.LoadFromFile("WriteExcel.xlsx");
            Worksheet sheet = workbook.Worksheets[0];

            int maxRow = sheet.LastRow;
            int maxColumn = sheet.LastColumn;
            for (int row = 1; row <= maxRow; row++)
            {
                for (int col = 1; col <= maxColumn; col++)
                {

                    Console.Write(sheet[row, col].Value);
                    Console.Write("\t\t");
                }
                Console.Write("\n");
            }

            Console.ReadKey();

For manipulating Excel files, you can visit the following documentation:

https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Spire.XLS-Program-Guide-Content.html