将excel表格导入到DataGridView

来源：互联网发布：卡特新秀赛季数据编辑：程序博客网时间：2024/05/17 02:36

using System.Data.OleDb;

添加一个button控件，一个textBox控件，用于显示选择路径

private void loadxls()        {                                  String  fileName = textBox1.Text;            String connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Members.xls;Extended Properties='Excel 8.0;HDR=YES;IMEX=1';";            string strSQL = "SELECT * FROM [Sheet1$]";            OleDbConnection excelConnection = new OleDbConnection(connectionString);            excelConnection.Open();        // This code will open excel file.            OleDbCommand dbCommand = new OleDbCommand(strSQL, excelConnection);            OleDbDataAdapter dataAdapter = new OleDbDataAdapter(dbCommand);            // create data table            DataTable dTable = new DataTable();            dataAdapter.Fill(dTable);            dataGridView1.DataSource = dTable;            dTable.Dispose();            dataAdapter.Dispose();            dbCommand.Dispose();            excelConnection.Close();            excelConnection.Dispose();                    }        private void button1_Click(object sender, EventArgs e)        {                      OpenFileDialog openFileDialog1 = new OpenFileDialog();            openFileDialog1.Filter = "Excel文件(*.xls)|*.xls";            if (openFileDialog1.ShowDialog() == DialogResult.OK)            {                               textBox1.Text = openFileDialog1.FileName;                loadxls();            }                       }