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

Top 5 Contributors of the Month
Sandeep Singh
Melody Anderson
Eminent IT

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


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

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);

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

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:


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

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