C#将Excel中的数据转换成DataSet
使用C#在不借助第三方插件的情况下将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();
}
}
以上所述就是本文的全部内容了，希望大家能够喜欢。