导入Excel

Question

谁能指出一下代码的错误
OpenFileDialog openFileDialog = new OpenFileDialog();
            openFileDialog.Filter = "Execl files (*.xls)|*.xls";
            openFileDialog.ShowDialog();
            if (openFileDialog.FileName.IndexOf(".") < 0)
            {
                return;
            }
            string path = openFileDialog.FileName;
            string fileName = path.Substring(path.LastIndexOf("\\") + 1);
            string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + path + ";" + "Extended Properties=Excel 8.0;";
            OleDbConnection conn = new OleDbConnection(strConn);
            string strExcel = "select * from [Sheet1$]";
            try
            {
                conn.Open();
                DataSet ds = new DataSet();
                OleDbDataAdapter adapter = new OleDbDataAdapter(strExcel, conn);
                adapter.Fill(ds);
                dgvCustomer.DataSource = ds;
                this.dgvCustomer.DataMember = ds.Tables[0].ToString();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
            finally
            {
                conn.Close();
            }
最后总是出错
说外部表不是预期的格式

Answer 1

检查Excel文件数据是否正确
Excel要符合二维表的形式
Excel第一列应为列名