Click here to Skip to main content
16,021,765 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i am novice in c# , i am creating a desktop application using visual c#, here i need to take excel file as a input and its corresponding data should be stored into the database. but i do not how to read the excel file , any hellp.................................



thank you in advance
Posted

 
Share this answer
 
Comments
Purushottam Prajapati 28-May-12 0:14am    
thanx
Prasad_Kulkarni 28-May-12 0:17am    
You're welcome!
Wendelius 28-May-12 0:16am    
Good links
Prasad_Kulkarni 28-May-12 0:18am    
Thanks Mika :)
One way is to use OleDb to access Excel data. Have a look at Reading and Writing Excel using OLEDB[^].

And another way is to use Interop[^], for example Faster MS Excel Reading using Office Interop Assemblies[^].
 
Share this answer
 
Comments
Prasad_Kulkarni 28-May-12 0:18am    
My 5!
Wendelius 28-May-12 0:21am    
Thanks :)
hello i give you one link i hope it will solve your problem.

Fast Excel file reader with basic functionality[^]
 
Share this answer
 

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