Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: ASP.NET SQL C#4.0 Excel
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 1:41am
Comments
   
How to automate Microsoft Excel from Microsoft Visual C#.NET
http://support.microsoft.com/kb/302084
Taresh Uppal at 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

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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

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

  Print Answers RSS
0 Kornfeld Eliyahu Peter 169
1 George Jonsson 145
2 Zoltán Zörgő 139
3 PIEBALDconsult 130
4 OriginalGriff 120
0 OriginalGriff 6,165
1 DamithSL 4,658
2 Maciej Los 4,107
3 Kornfeld Eliyahu Peter 3,649
4 Sergey Alexandrovich Kryukov 3,382


Advertise | Privacy | Mobile
Web02 | 2.8.141220.1 | Last Updated 11 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100