110,538
社区成员
发帖
与我相关
我的任务
分享
/// <summary>
/// 从Excel中读取数据
/// </summary>
/// <param name="excelPath"></param>
/// <param name="sheetName"></param>
/// <returns></returns>
public static DataSet GetDataFromExcel(string excelPath, string sheetName)
{
DataSet ds = new DataSet();
string strConn = "Provider=Microsoft.Jet.OleDb.4.0; Data Source=" + excelPath.ToString().Trim() + "; Extended Properties=Excel 8.0;";
try
{
using (OleDbConnection conn = new OleDbConnection(strConn))
{
conn.Open();
OleDbDataAdapter oda = new OleDbDataAdapter("select * from [" + sheetName + "$]", conn);
oda.Fill(ds);
}
}
catch
{
throw new Exception("获取Excel数据时发生异常...");
}
return ds;
}