Click here to Skip to main content
14,693,130 members
Please Sign up or sign in to vote.
3.50/5 (2 votes)
Hi all,

I am making a application where the user will upload the data into database as SQL using excel sheet. My concern is that I have to do a lot of validation checking on the sheet before we can finally upload the data into database from the sheet. I read about XSD but am not getting any idea how to achieve that. I mean directly reading the data from excel sheet and than comparing it with the predefined format and than if all is OK than uploading the contents to DB.
Please provide me with some idea or references.
Thank you !
Posted
Comments
José Amílcar Casimiro 11-Feb-13 6:43am
   
How to automate Microsoft Excel from Microsoft Visual C#.NET
http://support.microsoft.com/kb/302084
Taresh Uppal 11-Feb-13 7:04am
   
Hey Jose, Thanks for your time !
This provides me how to manipulate the data inside my excel sheet. However, I want is that like say If my excel is missing some column, If data type of some column is wrong, or if in a particular cell I need some custom data of specific pattern...How to achieve that ?

1 solution

I suggest you to read this great article: Excel Add-in Framework for Validating and Exporting Data[^].
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900