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();}

 

C#讀取Excel設定(親測可用)