i upload one excel document with more than one sheet and stored in dataset as data table.now i want to validate the dataset. if 'item no' is mandatory.the item number must be mandatory all sheets in excel sheet. if item number in 7 th row in all sheets but column value is different. how to validate, *All mandatory fields rows are same in all sheets but column is difference how to validate it.

Hello Dear, I bit confused about your requirement. You mention that ItemNo is mandatory in all sheet is that right? Can you tell me ItemNo column no is change or Not. If Column No is changed that not possible validate your data. I request to you share your excel sheet data of both sheet.

Joginder Banger Item number Row and column is changed based on sheet.

Answers

How to validate the excel sheet using ASP.NET C#?

Raja

513

i upload one excel document with more than one sheet and stored in dataset as data table.now i want to validate the dataset.<br /> if 'item no' is mandatory.the item number must be mandatory all sheets in excel sheet.<br /> if item number in 7 th row in all sheets but column value is different. how to validate,<br /> *All mandatory fields rows are same in all sheets but column is difference how to validate it.<br />