ASP.net连接Excel

首先添加命名空间

using System.Data.OleDb;

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

strfile = Request.QueryString["filename"];//从其他页面传过来的文件路径

Excel(strfile);

}

}

private void Excel(string filepath)

{

try

{

Dataset ds = new DataSet();

string ConnStr = "Provider=Microsoft.Jet.OleDb.4.0;data source=" + filepath +

";Extended Properties='Excel 8.0; HDR=YES; IMEX=1'";//连接Excel的字符串

string query = "SELECT * FROM [student$]";//Excel中的表名称

OleDbCommand oleCommand = new OleDbCommand(query, new OleDbConnection(ConnStr));

OleDbDataAdapter oleAdapter = new OleDbDataAdapter(oleCommand);

oleAdapter.Fill(ds, "[student$]");

rowcount = ds.Tables[0].Rows.Count;

gridview1.DataSource = ds;

gridview1.DataBind();

lblmes.Text = "上传成功，数据如下所示，请确认：";//lblmes为label，显示提示信息

}

catch (OleDbException)

{

string filename = filepath.Substring(filepath.LastIndexOf('/') + 1);

lblmes.Text = "错误！请确认上传文件是否正确！当前上传的文件为：" + filename;

lbtnSure.Visible = false;

}

catch(Exception ee)

{

lblmes.Text = ee.Message;

}

}