解析TABLE导入到EXCEL_.Net教程

编辑Tag赚U币
教程Tag:暂无Tag,欢迎添加,赚取U币!

推荐:解析ASP.NET页面数据导出到Excel或Word
privatevoidbtnMIME_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教程/更新时间:2010-02-01
相关.Net教程