Validating the Excel Data Fields with OpenXML Library

Question

I was trying to Take the Data from excel and if I wanted to check the validation there was a problem occurring like matching the header content to detailed can someone help me to get it resolved

Yazhini MP · Answer

You can try this method to validate, private void ValidateExcel() { try { var validator = new OpenXmlValidator(); int count = 0 foreach (ValidationErrorInfo error in validator.Validate(SpreadsheetDocument.Open(openFileGialog1.FileName, true))) { count++; lblError.Text += ("Error Count : " + count) + "
"; lblError.Text += ("Description : " + error.Description) + "
"; lblError.Text += ("Path: " + error.Path.XPath) + "
"; lblError.Text += ("Part: " + error.Part.XPath) + "
"; } Console.Readkey(); } catch (Exception ex) { lblError.Text += (ex.Message); } }

Leon D · Answer

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 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

Srinivasan Ramamoorthi · Answer

You can check this link https://support.microsoft.com/en-us/office/overview-of-xml-in-excel-f11faa7e-63ae-4166-b3ac-c9e9752a7d80

Validating the Excel Data Fields with OpenXML Library

Answers (3)