.net读取excel

 private void button1_Click(object sender, EventArgs e)
        {
            string xlsPath = "F:/exercise/test.xls"; // 绝对物理路径
            string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                            "Extended Properties=/"Excel 8.0;HDR=No;IMEX=1/";" +
                            "data source=" + xlsPath;
            // 查询语句
            string sql = "SELECT * FROM [Sheet1$]";
            DataSet ds = new DataSet();
            OleDbDataAdapter da = new OleDbDataAdapter(sql, connStr);
            da.Fill(ds);    // 填充DataSet       

            // 在这里对DataSet中的数据进行操作       

            // 输出，绑定数据
            dataGridView1.DataSource = ds.Tables[0].DefaultView;
          

        }