C#读取Excel设置(亲测可用)

 OpenFileDialog openFD = new OpenFileDialog();
            openFD.FileName = "";
            openFD.Filter = "xls|*.xls|xlsx|*.xlsx";
            openFD.Title = "选择更新文件";
            openFD.Multiselect = false;
            if (openFD.ShowDialog() == DialogResult.OK)
            {
                this.tbSelectFile.Text = openFD.FileName;
                //读取Excel
                pDataSet.Clear();
//成功的关键在于下面这句话，网上有很多不同版本，但这个是亲测可用的。
                string strConn = "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=" + openFD .FileName  + ";" + "Extended Properties=Excel 8.0;";
                OleDbConnection conn = new OleDbConnection(strConn);
                conn.Open();
                string strExcel = "";
                OleDbDataAdapter myCommand = null;
                strExcel = "select * from [sheet1$]";
                myCommand = new OleDbDataAdapter(strExcel, strConn);
                myCommand.Fill(pDataSet , "table1");
                conn.Close();
}

 

转载于:https://www.cnblogs.com/pengdage110/p/4244777.html