excel

[TAREQ F ABUZUHRI]

how can read information within excel file from C# application

Palestine

[Nisar Inamdar]

:cool:What u mean.....? Describe little more... So i can help u? Nisar Inamdar. Always for u...

[Vasudevan Deepak Kumar]

Excel ODBC Driver http://www.codeproject.com/database/excel_odbc.asp[^]

Vasudevan Deepak Kumar Personal Homepage Tech Gossips

[Giorgi Dalakishvili]

You can use the OleDb Managed Data Provider to read an Excel Spreadsheet using ADO.NET and C#

#region signature my articles #endregion

[TAREQ F ABUZUHRI]

see this excel file http://paltareq.brinkster.net/down/complete\_apps\_rep.xls in my c# application i want to make for loop to read each cell in the file ?

Palestine

[Bhavesh Bagadiya]

You can use InterOp service provided by Microsoft using Excel namespace. namespace for Excel is, Microsoft.Office.Interop.Excel

[laddie 0]

TAREQ Try this using System.Data.OleDb; using System.Data; . . //I am not sure giving url in the filename will work.Please check it OleDbConnection oleConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+fileName+@";Extended Properties=""Excel 8.0;HDR=YES"""); oleConenction.Open(); OleDbCommand cmd= new OleDbCommand("select * from [Sheet1$]",oleConnection); OleDbDataReader read = cmd.ExecuteReader(); while(read.Read()) { Console.WriteLine(read[0]+......); } Please let me know if it helps Laddie }

[laddie 0]

Hi Bhavesh, Just a gentle suggestion. This solution needs that you either assumes Office to be installed in the machine or you have to distubute the office libraries along with the Apps. Please find my last post for this question it sould provide a better and faster solution. laddie