知行网

#region 获取Excel中的数据，返回DataTable
/// <summary>
/// 获取Excel中的数据，返回DataTable
/// </summary>
/// <param name="filename">Excel的文件路径</param>
/// <param name="comText">Excel查询字符串</param>
/// <returns>DataTable</returns>
public static DataTable GetXlsDataTable(string filename,string comText)
{
try
{
con= new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";Extended Properties=Excel 8.0;");
con.Open();
OleDbDataAdapter adapter = new OleDbDataAdapter(comText, con);
DataTable table = new DataTable();
adapter.Fill(table);
return table;
}
catch (Exception ex)
{
exceptionMessage = ex.Message;
return null;
}
finally
{
con.Close();
}
}
#endregion