读取Excel中的数据

public static DataTable ExcelTableByOleDB(string strExcelPath, string tableName)
{

try
{
tableName = string.Format("{0}$", tableName);
DataTable dtExcel = new DataTable();
//数据表
DataSet ds = new DataSet();
//Excel的连接
OleDbConnection objConn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strExcelPath + ";" + "Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=1;\"");
if (objConn == null)
{
return null;

}
objConn.Open();
string strSql = "select * from [" + tableName + "]";
OleDbDataAdapter myData = new OleDbDataAdapter(strSql, objConn);
myData.Fill(ds, tableName);//填充数据
objConn.Close();
dtExcel = ds.Tables[tableName];
return dtExcel;
}

catch (Exception ex)
{
throw new Exception(ex.Message);
return null;
}

}