解析TABLE导入到EXCEL_.Net教程
教程Tag:暂无Tag,欢迎添加,赚取U币!
推荐:解析ASP.NET页面数据导出到Excel或WordprivatevoidbtnMIME_Click(objectsender,System.EventArgse) { BindData(); Response.ContentType=application/vnd.ms-Excel; Response.AddHeader(Content-Disposition,inline;filename= +HttpUtility.UrlEncode(下载文件.xls,Encoding.UTF8)); //如
前台代码:ExportExcel1.aspx <%@ Page Language="C#" AutoEventWireup="true" CodeFile="ExportExcel1.aspx.cs" Inherits="ExportExcel1" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>导出数据到EXCEL</title> </head> <body> <h3>Table Example, constructed programmatically</h3> <form id="Form1" runat=server> <asp:Table id="Table1" GridLines="Both" HorizontalAlign="Center" Font-Name="Verdana" Font-Size="8pt" CellPadding=15 CellSpacing=0 Runat="server"/> <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="导出数据" /> </form> </body> </html> |
后台代码:ExportExcel1.aspx .cs
using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.IO; public partial class ExportExcel1 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { // Generate rows and cells. TableRow r = new TableRow(); TableCell c1 = new TableCell(); c1.ColumnSpan = 2; c1.Text = "test"; c1.HorizontalAlign = HorizontalAlign.Center; r.Cells.Add(c1); Table1.Rows.Add(r); int numrows = 3; int numcells = 2; for (int j=0; j<numrows; j++) { TableRow r1 = new TableRow(); for (int i=0; i<numcells; i++) { TableCell c = new TableCell(); c.Controls.Add(new LiteralControl("row " + j.ToString() + ", cell " + i.ToString())); r1.Cells.Add(c); } Table1.Rows.Add(r1); } } protected void Button1_Click(object sender, EventArgs e) { DateTime dt = System.DateTime.Now;//取出当前系统日期时间 string dtt = dt.Year.ToString() + dt.Month.ToString() + dt.Day.ToString();//取出系统日期 string filestr = "C:\\excel"; //filestr是文件的路径 StringWriter stringWriter = new StringWriter(); HtmlTextWriter htmlWriter = new HtmlTextWriter(stringWriter); Table1.RenderControl(htmlWriter); string file = filestr + "\\" + dtt + ".xls"; if (!Directory.Exists(filestr)) { Directory.CreateDirectory(filestr); } System.IO.StreamWriter sw = new StreamWriter(file); sw.Write(stringWriter.ToString()); sw.Close(); } } |
分享:解析简单实用的DataGrid自定义分页源程序首先新建一个名为article.aspx的文件,将以下内容拷贝到article.aspx.cs中: usingSystem; usingSystem.Data; usingSystem.Configuration; usingSystem.Collections; usingSystem.Web; usingSystem.Web.Security; usingSystem.Web.UI; usingSystem.Web.UI.WebCo
相关.Net教程:
- asp.net如何得到GRIDVIEW中某行某列值的方法
- .net SMTP发送Email实例(可带附件)
- js实现广告漂浮效果的小例子
- asp.net Repeater 数据绑定的具体实现
- Asp.Net 无刷新文件上传并显示进度条的实现方法及思路
- Asp.net获取客户端IP常见代码存在的伪造IP问题探讨
- VS2010 水晶报表的使用方法
- ASP.NET中操作SQL数据库(连接字符串的配置及获取)
- asp.net页面传值测试实例代码
- DataGridView - DataGridViewCheckBoxCell的使用介绍
- asp.net中javascript的引用(直接引入和间接引入)
- 三层+存储过程实现分页示例代码
- 相关链接:
- 教程说明:
.Net教程-解析TABLE导入到EXCEL。