How to populate listbox from excel using C#

Question

I have an windows application. I browse for the file and select the excel file using OpenFileDialog control. The excel file contains email id's in column A. I want to populate the list-box with excel file column values. Office 2003 is installed on my machine. Can somebody Please help me out? Thanks in Advance.

possible duplicate of Reading Excel files from C#

Jeremy Thompson
– Jeremy Thompson

2012-06-05 23:49:07 +00:00
Commented Jun 5, 2012 at 23:49 — Jeremy Thompson
– Jeremy Thompson, Commented Jun 5, 2012 at 23:49

Community · Accepted Answer · 2017-05-23 12:03:13Z

1

Refer: Reading Excel files from C#

To connect to an excel file you need the appropriate connection string:

string connString = @"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=<YourExcelPath>;
Extended Properties=\"Excel 12.0;HDR=YES;\"";

After use the OleDb classes to query the information from the file:

string selectCmd = "SELECT * FROM <SheetName>";

using(OleDbConnection excelConn = new OleDbConnection(connString))
{
    excelConn.Open(); 
    OleDbCommand command = new OleDbCommand(selectCmd, excelConn);
    OleDbDataAdapter da = new OleDbDataAdapter(command);

    DataTable sheetInfo = new DataTable();
    dataAdapter.Fill(sheetInfo);

    //Do something with the data.
    Bind your control with this datatable here
}

So you need to replace "YourExcelPath" with the path of your excel file..

edited May 23, 2017 at 12:03

CommunityBot

11 silver badge

answered Jun 5, 2012 at 11:18

Niranjan Singh

18.3k2 gold badges45 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to populate listbox from excel using C#

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related