我要评论复制代码 代码如下:
/// <summary>
/// excel数据转换dataset
/// </summary>
/// <param name="filepath">文件全路径</param>
/// <param name="search">表名</param>
/// <returns></returns>
private dataset getdataset(string filename)
{
string strconn = "provider=microsoft.ace.oledb.12.0;data source=" + filename + ";extended properties='excel 12.0;hdr=yes;imex=1';";
oledbconnection objconn = null;
objconn = new oledbconnection(strconn);
objconn.open();
dataset ds = new dataset();
//list<string> list = new list<string> { "收款金额", "代付关税", "垫付费用", "超期", "到账利润" };
list<string> list = new list<string> { };
datatable dtsheetname = objconn.getoledbschematable(oledbschemaguid.tables, new object[] { null, null, null, "table" });
foreach (datarow dr in dtsheetname.rows)
{
if (dr["table_name"].tostring().contains("$") && !dr[2].tostring().endswith("$"))
{
continue;
}
string s = dr["table_name"].tostring();
list.add(s);
}
try
{
for (int i = 0; i < list.count; i++)
{
ds.tables.add(list[i]);
string sheetname = list[i];
string strsql = "select * from [" + sheetname + "]";
oledbdataadapter odbccsvdataadapter = new oledbdataadapter(strsql, objconn);
datatable dt = ds.tables[i];
odbccsvdataadapter.fill(dt);
}
return ds;
}
catch (exception ex)
{
return null;
}
finally
{
objconn.close();
objconn.dispose();
}
}
您可能感兴趣的文章:
如您对本文有疑问或者有任何想说的，请点击进行留言回复，万千网友为您解惑！
网友评论