导出
protected void Button1_Click(object sender, EventArgs e) { Export("application/ms-excel", "员工信息.xls"); } // 定义导出Excel的函数 private void Export(string FileType, string FileName) { string style = @"<style> .text { mso-number-format:\@; } </script> "; Response.Charset = "GB2312"; Response.ContentEncoding = System.Text.Encoding.UTF8; HttpContext.Current.Response.Write("<meta http-equiv=Content-Type content=text/html;charset=UTF-8>"); Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString()); Response.ContentType = FileType; //Response.ContentType = "application/excel"; this.EnableViewState = false; StringWriter tw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(tw); GridView1.RenderControl(hw); Response.Write(style); Response.Write(tw.ToString()); Response.End(); } // 此方法必重写,否则会出错 public override void VerifyRenderingInServerForm(Control control) { } protected void Button2_Click(object sender, EventArgs e) { Export("application/ms-word", "员工信息.doc"); }
导入:
string strCon; strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~/Files/Employee.xls") + ";Extended Properties=Excel 8.0;"; OleDbConnection con = new OleDbConnection(strCon); OleDbDataAdapter da = new OleDbDataAdapter("select * from [Sheet1$]", con); DataSet ds = new DataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind();