将Excel文件绑定到datagridview [英] Binding excel file to datagridview

问题描述

我正在尝试将excel文件绑定到 dataGridView

I am trying to bind excel file to dataGridView

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;"
                + "Data Source=E://Org.xls;" 
                + "Extended Properties=" + (char)34 
                + "Excel 8.0;HDR=Yes;" + (char)34;
            OleDbConnection conn = new OleDbConnection(strConn);
            textBox1.Text = "test";
            OleDbCommand command = new OleDbCommand("Select * from [Sheet1$]", conn);
            conn.Open();
            dataGridView1.DataSource = command.ExecuteReader(); 



            conn.Close();

但是网格视图不显示任何内容。

But grid view doesn't show anything. It doesn't give error either

推荐答案

这里也没有错误，只需更改excel文件的路径和

Heres how to do it, just need to change the path for the excel file and the reference to the grid.

    OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c://Org.xls;Extended Properties=" + (char)34 + "Excel 8.0;HDR=Yes;" + (char)34);
    DataSet myExcelData=new DataSet();

    conn.Open();

    OleDbDataAdapter myDataAdapter = new OleDbDataAdapter("Select * from [Sheet1$]", conn);
    myDataAdapter.Fill(myExcelData);

    ultraGrid1.DataSource = myExcelData;

    conn.Close(); 

这篇关于将Excel文件绑定到datagridview的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！