??????? public static System.Data.DataSet ExcelConnection(string filepath, string exName, string tableName, out string errmsg)
??????? {
??????????? errmsg = "";
??????????? string strCon = "";
??????????? if (exName == ".xls")
??????????????? strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1'";
??????????? if (exName == ".xlsx")
??????????????? strCon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filepath + ";Extended Properties=\"Excel 12.0;HDR=YES\"";
??????????? System.Data.OleDb.OleDbConnection ExcelConn = new System.Data.OleDb.OleDbConnection(strCon);
??????????? try
??????????? {
??????????????? ExcelConn.Open();
??????????????? DataTable dt = ExcelConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);
??????????????? if (dt == null)
??????????????????? return null;
??????????????? string excelSheet = dt.Rows[0]["TABLE_NAME"].ToString();
??????????????? string strCom = string.Format("SELECT * FROM [" + excelSheet + "]");
??????????????? System.Data.OleDb.OleDbDataAdapter myCommand = new System.Data.OleDb.OleDbDataAdapter(strCom, ExcelConn);
??????????????? DataSet ds = new DataSet();
??????????????? myCommand.Fill(ds, tableName);
??????????????? ExcelConn.Close();
??????????????
??????????????? return ds;
??????????? }
??????????? catch(Exception ex)
??????????? {
??????????????? errmsg = ex.Message;
??????????????? ExcelConn.Close();
??????????????? return null;
??????????? }
??????? }
更多文章、技術(shù)交流、商務(wù)合作、聯(lián)系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號(hào)聯(lián)系： 360901061
您的支持是博主寫作最大的動(dòng)力，如果您喜歡我的文章，感覺我的文章對(duì)您有幫助，請(qǐng)用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點(diǎn)擊下面給點(diǎn)支持吧，站長(zhǎng)非常感激您！手機(jī)微信長(zhǎng)按不能支付解決辦法：請(qǐng)將微信支付二維碼保存到相冊(cè)，切換到微信，然后點(diǎn)擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對(duì)您有幫助就好】元
