[C++] C#读取excel文件的内容(使用DataSet)

1 public DataSet ReadFile(string filePath)
 2     {
 3       string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Extended Properties=Excel 12.0;"; 
 4       OleDbConnection conn = new OleDbConnection(strConn);
 5       conn.Open();
 6       string strExcel = "select * from [sheet3$]";
 7       OleDbDataAdapter da = new OleDbDataAdapter(strExcel, strConn);
 8       DataSet ds = new DataSet();
 9       try
10       {
11         da.Fill(ds);
12       }
13       catch (Exception ex)
14       {
15         throw new Exception("读取Excel失败：" + ex.Message);
16       }
17       return ds;
18     }