how to validate excel sheet before uploading its data to database.

Question

3.50/5 (2 votes)

See more:

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 11-Feb-13 0:41am

Taresh Uppal

Add a Solution

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

Add a Solution

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

Maciej Los · Answer 1 · 2013-02-11T01:16:00

Solution 1

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

Posted 11-Feb-13 1:16am

Maciej Los

how to validate excel sheet before uploading its data to database.

1 solution

Solution 1

Add your solution here

Preview 0

how to validate excel sheet before uploading its data to database.

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us