C# code to read excel files

[sibuyihm]

Hi Guys,
My name is Henry, I'm a new member. I need to know how to read cells from an excel spreadsheet using C#. Can anyone please assist.

[kenobewan]

Welcome to the site. What have you tried so far? If you search the site you are likely to find examples.

[r035198x]

Welcome to the site. What have you tried so far? If you search the site you are likely to find examples.

Hint: ADO.NET

[Curtis Rutland]

If you look in the Howtos section, there are two articles about using Databases in your .NET program. Read them.

You can treat a spreadsheet as a database. Go to connectionstrings.com to find the connection string for connecting to Excel.

[sibuyihm]

Thanks guys, I got it. Here's how it goes in case anyone else needs

public DataTable Connect()
        {
            string connStr;
            connStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Practice.xls;Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'";
            OleDbConnection con = new OleDbConnection(connStr);
            con.Open();
            string Query = "SELECT * FROM [Sheet1$]";
            DataTable Table = new DataTable();
            OleDbDataAdapter adapt = new OleDbDataAdapter(Query, con);
            adapt.Fill(Table);
            con.Close();
            return Table;
        }       
 
private void button1_Click_1(object sender, EventArgs e)
        {
            int num = Connect().Rows.Count;
            string server, account, Password;
 
            listBox1.Items.Clear();
            for (int i = 0; i < num; i++)
            {
                server = Connect().Rows[i]["Host"].ToString();
                account = Connect().Rows[i]["Account"].ToString();
                Password = Connect().Rows[i]["Passwd"].ToString();
                listBox1.Items.Add(i + "\t" + server + "\t\t " + account + "\t\t" + Password);
            }
        }

[Curtis Rutland]

Just so you know, that's not the most efficient way to do things.

Every time you call Connect() you are redoing your whole query. What you should do is something like this:

DataTable dt = Connect();
int num = dt.Rows.Count;
.
.
.
 

That way, you only run the query once.