.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> C# >> Post New QuestionBookmark and Share Subscribe to Forum

EXcel

Posted By: akash     Posted Date: December 09, 2010    Points:2   Category :C#
How to read cell values from an excel document

Responses
Author: SureshM             
Posted Date: December 09, 2010     Points: 5   

hi akash.

This will help u..


using System.Data.OleDb;

OleDbConnection con = null;

String conStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + "ur excel file path" + @";Extended Properties=""Excel 8.0;HDR=YES;IMEX=1;ImportMixedTypes=Text """;

con = new OleDbConnection(conStr); con.Open();
dtSheets = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
con.Close();


Author: praveeragul             
Posted Date: December 11, 2010     Points: 5   

Testing Training In Chennai - Accord Info Matrix Pvt. Ltd is a Chennai based Software Firm. Our main focus areas are Software Training, Software Development and HR Consultancy.Testing Training In Chennai.
The courses conduct mcse training chennai , mcse training in chennai,mcse classes in chennai,mcitp training in chennai,mcts training in chennai,best mcse training in chennai,mcitp training in chennai
www.accordsoft.in

Author: Syed Shakeer Hussain             
Posted Date: December 11, 2010     Points: 5   
Author: Hannah             
Posted Date: December 26, 2013     Points: 20   

You can read excel file using c# with Aspose.Cells for .NET Library. You will find many other features in this library that you can use in your application. You can check the details of this library on the link given below:

http://www.aspose.com/.net/excel-component.aspx



Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend