Code666 (代码贴、代码片段)

[C#] C# 通过oledb读取excel表格内容到datatable →→→→→进入此内容的聊天室

来自 , 2021-03-29, 写在 C#, 查看 149 次.
URL http://www.code666.cn/view/0f65caf0
  1. string strCon = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excel_path + ";Extended Properties='Excel 12.0;HDR=YES;IMEX=1'";  
  2. OleDbConnection myConn = new OleDbConnection(strCon);  
  3. string strCom = "SELECT * FROM [Part$A7:AK] where [Part No]=10506";  
  4. myConn.Open();  
  5. OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn);  
  6. DataSet myDataSet = new DataSet();  
  7. myCommand.Fill(myDataSet, "Part");  
  8. myConn.Close();  
  9.  
  10.  
  11. //csharp/6148

回复 "C# 通过oledb读取excel表格内容到datatable"

这儿你可以回复上面这条便签

captcha

贴代码片段 - Code666