Excel转化为DataTable 

 1         public static DataSet ExcelToDataSet(string filename)  //函数用来读取一个excel文件到DataSet集中  
 2         {
 3             string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;" +
 4                             "Extended Properties=Excel 8.0;" +
 5                             "data source=" + filename;
 6             OleDbConnection myConn = new OleDbConnection(strCon);
 7             string strCom = " SELECT * FROM [Sheet1$]";     //"Sheet1"为表单标签页名  
 8             myConn.Open();
 9             OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn);
10             DataSet ds;
11             ds = new DataSet();
12             myCommand.Fill(ds);
13             myConn.Close();
14             return ds;
15         }
View Code

参数  filename:为文件路径

string strCom = " SELECT * FROM [Sheet1$]";     //"Sheet1"为表单标签页名     **$是必须存在的

posted @ 2021-01-07 10:21  YZM_Leo  阅读(114)  评论(0)    收藏  举报