public DataSet ImportExcel(string strFileName, string sheet)
{
DataSet ds = new DataSet();
if (strFileName != "")
{
string conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFileName + ";Extended Properties=/"Excel 8.0;IMEX=1/" ";
string sql = "select * from [" + sheet + "$]";
OleDbDataAdapter da = new OleDbDataAdapter(sql, conn);
try
{
da.Fill(ds);
}
catch (Exception ex)
{
Response.Write("数据格式不对!" + ex.Message);
}
return ds;
}
else
{
return null;
}
}