日期:2014-05-17 浏览次数:20605 次
public DataSet ExecleDs(string filenameurl,string table)
{
string strConn = "Provider=Microsoft.Jet.OleDb.4.0;" + "data source=" +filenameurl+ ";Extended Properties='Excel 8.0; HDR=YES; IMEX=1'";
OleDbConnection conn = new OleDbConnection(strConn);
OleDbDataAdapter odda = new OleDbDataAdapter("select * from [Sheet1$]", conn);
DataSet ds = new DataSet();
odda.Fill(ds,table);
return ds;
}
string strpath = FileUpload1.PostedFile.FileName.ToString();
//获取Execle文件路径
string filename = FileUpload1.FileName;
//获取Execle文件名
DataSet ds = ExecleDs(strpath,filename);