TABLE 导入到EXCEL

最新推荐文章于 2025-12-26 14:24:35 发布

转载最新推荐文章于 2025-12-26 14:24:35 发布 · 296 阅读

文章标签：

#table #button #server #string #xhtml #object

ASP.NET 专栏收录该内容

15 篇文章

订阅专栏

本文介绍了一个使用ASP.NET实现将数据导出为Excel文件的例子。通过在页面上生成表格，并利用按钮触发导出操作，可以将网页上的数据保存为Excel文件。此方法适用于简单的数据导出场景。

前台代码：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(); } }

转:http://hi.baidu.com/worry_js/blog/item/dbbfbad50323c109a08bb772.html