将excel中的数据导入datagridview中

  /// <summary>
        /// 将excel中的数据导入datagridview中
        /// </summary>
        public void ExcelIntoDatagridView()
        {
            ArrayList arratlist = new ArrayList();
            //打开一个文件选择框  
            OpenFileDialog ofd = new OpenFileDialog();
            ofd.Title = "Excel文件";
            ofd.FileName = "";
            ofd.Filter = "Excel文件(*.xls)|*.xls";
            try
            {

                if (ofd.ShowDialog() == DialogResult.OK)
                {
                    string tableName = "";
                    if (arratlist != null)
                    {
                        arratlist.Clear();
                    }
                    string Path = ofd.FileName;
                    string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Path + ";" + "Extended Properties=Excel 8.0;";
                    OleDbConnection conn = new OleDbConnection(strConn);
                    conn.Open();
                    System.Data.DataTable schemaTable = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);
                    tableName = schemaTable.Rows[0][2].ToString().Trim();
                    for (int i = 0; i < schemaTable.Rows.Count; i++)
                    {
                        arratlist.Add(schemaTable.Rows[i][2].ToString().TrimStart('/'').Trim('/'', '$'));//  
                    }
                    arratlist.Sort();
                    string strExcel = "Select   *   From   [" + tableName + "]";
                    OleDbCommand cmd = new OleDbCommand(strExcel, conn);
                    DataTable excelDt = new DataTable();
                    OleDbDataAdapter da = new OleDbDataAdapter(strExcel, conn);
                    da.Fill(excelDt);
                    conn.Close();
                    MessageBox.Show("excel 导入成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    if (excelDt != null)
                    {
                        dataGridView1.DataSource = excelDt;
                    }
                }
            }
            catch (Exception ex)
            {

                MessageBox.Show("导入文件时出错,文件可能正被打开", "提示");
            }

        }