excel validation before upload to database

Posted by Kavi.Sirius under C# on 5/23/2012 | Points: 10 | Views : 5052 | Status : [Member] | Replies : 1
how to check the excell cell data is in date format mm/dd/yyyy and show error if not present
how to check header of excel matches with database table

Regards
Kavi.n



Responses

Posted by: Ajay.Kalol on: 6/4/2012 [Member] Starter | Points: 25

Up
0
Down
You can Put Validation for Date in Excel file.
and for Reading Excel
Try on this link
http://www.dotnetfunda.com/articles/article1370-reading-opening-excel-file-in-csharp-using-microsoftofficeintropexcel-objec.aspx

Enjoy...

Ajay
ajaypatelfromsanthal.blogspot.in

Kavi.Sirius, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response