.net页面导出Excel表
我最近在研究页面如何导出Excel表.有源码的发到我的邮箱juan13718798912@163.com. --------------------编程问答----------------------------------------编程问答-------------------- 上面没改好·
DataSet ds = new DataSet();
//先创建一张表
DataTable table = new DataTable();
//指定表中的列名
table.Columns.Add("XXX");
table.Columns.Add("XXX");
//创建一行数据
DataRow row = table.NewRow();//创建一行和先前制定的表的结构相同
row[dayin.Xsr] = this.txtXiaoShouRen.Text;
row[dayin.Ku] = this.txtKeHu.Text;
//把一行数据添加到表中
table.Rows.Add(row);
ds.Tables.Add(table);
GridView gv = new GridView();
gv.DataSource = ds;
gv.DataBind();
Response.Buffer = true;
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
Response.ContentType = FileType;
this.EnableViewState = false;
StringWriter tw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw);
gv.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();
DataSet ds = new DataSet();
//先创建一张表
DataTable table = new DataTable();
//指定表中的列名
table.Columns.Add("列名1");
table.Columns.Add("列名2");
//创建一行数据
DataRow row = table.NewRow();//创建一行和先前制定的表的结构相同
row["列名1"] = 给列1赋值;
row["列名2"] = 给列2赋值;
//把一行数据添加到表中
table.Rows.Add(row);
ds.Tables.Add(table);
GridView gv = new GridView();
gv.DataSource = ds;
gv.DataBind();
Response.Buffer = true;
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
Response.ContentType = FileType;
this.EnableViewState = false;
StringWriter tw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw);
gv.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();
--------------------编程问答-------------------- 已发送到你的邮箱,记得查收! --------------------编程问答-------------------- 现在还有些第三方控件,可以直接支持导出。很方便
补充:.NET技术 , ASP.NET