寻求 web excel出力控件

wangxianshou 2010-09-14 10:44:25

最近打算用button+datagrid作一个自定义控件
不怎么会写，那位仁兄能帮忙下

用户控件（ascx）好整



using System;

using System.Collections;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Web;

using System.Web.Mobile;

using System.Web.SessionState;

using System.Web.UI;

using System.Web.UI.MobileControls;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

using System.IO;

using System.Text;





public partial class WebUserControl : System.Web.UI.MobileControls.MobileUserControl

{

    protected void Page_Load(object sender, EventArgs e)

    {

    }

    private DataSet excelDataSource;

    public DataSet ExcelDataSource

    {

        get { return excelDataSource; }

        set { excelDataSource = value; }

    }

    private string execlName;

    public string ExcelName

    {

        get { return execlName; }

        set { execlName = value; }

    }

    protected void btnExportExcel_Click(object sender, EventArgs e)

    {

        Response.Buffer = true;

        Response.Charset = "utf-8";

        Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(execlName.Replace(":", ""), Encoding.UTF8) + ".xls");

        Response.ContentEncoding = System.Text.Encoding.Default;//.GetEncoding("utf-8");//

        Response.ContentType = "application/ms-excel";

        this.EnableViewState = false;

        StringWriter oStringWriter = new StringWriter();

        HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter);

        dgExcel.Visible = true;

        dgExcel.DataSource = null;

        dgExcel.DataMember = excelDataSource.Tables[0].TableName;

        dgExcel.DataSource = excelDataSource.Tables[0];

        dgExcel.DataBind();

        dgExcel.HeaderStyle.BackColor = System.Drawing.Color.Yellow;

        dgExcel.RenderControl(oHtmlTextWriter);

        Response.Write(oStringWriter.ToString());

        Response.End();

        dgExcel.DataSource = null;

        dgExcel.Visible = false;

    }

}



    protected void WEBExportExcel1_Load(object sender, EventArgs e)

    {

        ConDataBase con = new ConDataBase();

        string strSQL = "xxxxx";

        DataSet ds = new DataSet();

        ds = con.getDataSetBySQL(strSQL);

        this.WEBExportExcel1.ExcelDataSource = ds;

        this.WEBExportExcel1.ExcelName="wangxianshou"+DateTime.Now.ToLongDateString();

       

    }

...全文