将excel数据转换成dataset示例

///<summary>
       ///EXCEL数据转换DataSet
       ///</summary>
       ///<paramname="filePath">文件全路径</param>
       ///<paramname="search">表名</param>
       ///<returns></returns>      
       privateDataSetGetDataSet(stringfileName)
       {
           stringstrConn="Provider=Microsoft.ACE.OLEDB.12.0;DataSource="+fileName+";ExtendedProperties="Excel12.0;HDR=Yes;IMEX=1";";
           OleDbConnectionobjConn=null;
           objConn=newOleDbConnection(strConn);
           objConn.Open();
           DataSetds=newDataSet();
           //List<string>List=newList<string>{"收款金额","代付关税","垫付费用","超期","到账利润"};
           List<string>List=newList<string>{};
           DataTabledtSheetName=objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,newobject[]{null,null,null,"TABLE"});
           foreach(DataRowdrindtSheetName.Rows)
           {
               if(dr["Table_Name"].ToString().Contains("$")&&!dr[2].ToString().EndsWith("$"))
               {
                   continue;
               }
               strings=dr["Table_Name"].ToString();
               List.Add(s);
           }
           try
           {
               for(inti=0;i<List.Count;i++)
               {
                   ds.Tables.Add(List[i]);
                   stringSheetName=List[i];
                   stringstrSql="select*from["+SheetName+"]";
                   OleDbDataAdapterodbcCSVDataAdapter=newOleDbDataAdapter(strSql,objConn);
                   DataTabledt=ds.Tables[i];
                   odbcCSVDataAdapter.Fill(dt);
               }
               returnds;
           }
           catch(Exceptionex)
           {
               returnnull;
           }
           finally
           {
               objConn.Close();
               objConn.Dispose();
           }
       }