TABLE导入到EXCEL

最新推荐文章于 2024-05-30 15:52:26 发布

weixin_30670925

最新推荐文章于 2024-05-30 15:52:26 发布

阅读量86

点赞数

文章标签： xhtml ui c#

原文链接：http://www.cnblogs.com/princessEE/archive/2009/10/03/1577714.html

版权

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

    }
}

转载于:https://www.cnblogs.com/princessEE/archive/2009/10/03/1577714.html

weixin_30670925

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
TABLE导入到EXCEL

前台代码：ExportExcel1.aspx<%@PageLanguage="C#"AutoEventWireup="true"CodeFile="ExportExcel1.aspx.cs"Inherits="ExportExcel1"%> <!DOCTYPEhtmlPUBLIC"-//W3C//DTDXHTML1.0Tran...
复制链接

扫一扫