asp.net 导出Excel

最新推荐文章于 2018-11-24 17:44:20 发布

转载最新推荐文章于 2018-11-24 17:44:20 发布 · 129 阅读

文章标签：

#asp.net #dataset #exception #excel #string #object

asp.net 专栏收录该内容

2 篇文章

订阅专栏

本文介绍了一种使用ASP.NET进行Excel导出的方法，无需依赖额外组件或DLL。通过直接构建Excel文件的内容并将其作为HTTP响应返回给客户端，实现了表格数据的导出功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

asp.net无组件导出Excel

最近要做个一导出数据功能，网上找了下，没有找到有的说要Excel.dll等等导出pdf好像需要第三方dll支持

下边是我导出Excel的源码大家谁有好的解决方案不防给我介绍下源码里的数据是我模拟的

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.IO;

public partial class ReportExel : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        DataSet ds = new DataSet();
        DataTable dt = new DataTable();
        DataColumn coll = dt.Columns.Add("Title", typeof(string));
        coll.AllowDBNull = false;
        coll.Unique = true; DataRow dr;

        for (int i = 0; i < 10; i++)
        {
            dr = dt.NewRow();//新行 
            dr["Title"] = "第" + i + "列数据";
            dt.Rows.Add(dr);
        }

        ds.Tables.Add(dt);


        ExportDataToExcel(dt, "续办人事代理");
        //CreateExcel(ds, "aa.xls");
    }





    /// <summary>
    /// 
    /// </summary>
    /// <param name="dt"></param>
    /// <param name="strFileName">含.xls</param>
    public static void ExportDataToExcel(DataTable dt, string FileName)
    {
        try
        {
            StringWriter sw = new StringWriter();
            string colstr = "";
            foreach (DataColumn col in dt.Columns)
            {
                colstr += col.ColumnName + "\t";
            }
            sw.WriteLine(colstr);

            foreach (DataRow row in dt.Rows)
            {
                colstr = "";
                foreach (DataColumn col in dt.Columns)
                {
                    colstr += row[col.ColumnName].ToString() + "\t";
                }
                sw.WriteLine(colstr);
            }
            sw.Close();
            HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName + ".xls", System.Text.Encoding.UTF8));
            HttpContext.Current.Response.ContentType = "application/ms-excel";
            System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default;
            System.Web.HttpContext.Current.Response.Write(sw);
            System.Web.HttpContext.Current.Response.End();
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }




     public static void ExportDataToExcelByWeb(DataTable dt,System.Web.UI.WebControls.DataGrid DGOutPut,string FileName)
        {
            try
            {
                DGOutPut.Visible=true;
                DGOutPut.DataSource=dt;
                DGOutPut.DataBind();
                System.Web.HttpContext.Current.Response.Clear();
                System.Web.HttpContext.Current.Response.Buffer = true;
                System.Web.HttpContext.Current.Response.Charset = "GB2312";
                System.Web.HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename="+FileName+".xls");
                System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文
                System.Web.HttpContext.Current.Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。 
                DGOutPut.EnableViewState = false;
                System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);
                System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
                System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
                DGOutPut.RenderControl(oHtmlTextWriter);
                System.Web.HttpContext.Current.Response.Write(oStringWriter.ToString());
                System.Web.HttpContext.Current.Response.End();
                DGOutPut.Visible=false;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

   



}