把DataTable导出到Excel

最新推荐文章于 2023-04-19 09:47:06 发布

redder_xu

最新推荐文章于 2023-04-19 09:47:06 发布

阅读量956

点赞数

CC 4.0 BY-SA版权

分类专栏： webform winform 文章标签： excel string

本文链接：https://blog.youkuaiyun.com/redder_xu/article/details/6856569

winform 同时被 2 个专栏收录

47 篇文章

订阅专栏

webform

18 篇文章

订阅专栏

本文将介绍如何使用C#和Excel组件创建一个功能，用于从数据表中导出Excel文件，并设置相应的响应头以实现下载。通过实例演示了如何使用Excel对象模型和.NET框架来完成这一任务。

public static void DownExcelData(this Page thispage,DataTable dataTable,string title)
{

            Workbook wb = new Workbook();
            wb.Worksheets.Clear();
            wb.Worksheets.Add(SheetType.Worksheet);
            var ws = wb.Worksheets[0];
            ws.Name = title;
            ws.Cells.ImportDataTable(dataTable, true, "A1");
            var m = wb.SaveToStream();
            var buff = m.ToArray();

var httpRenponse = System.Web.HttpContext.Current.Response;

            httpRenponse.Clear();
            httpRenponse.Charset = "GB2312";
            httpRenponse.Buffer = true;
            thispage.EnableViewState = false;
            httpRenponse.ContentEncoding = System.Text.Encoding.Default;
            httpRenponse.AppendHeader("Content-Disposition", string.Format("attachment;filename=" + System.Web.HttpUtility.UrlEncode(title + ".xls", Encoding.UTF8)));
            thispage.Response.ContentType = "application/vnd.ms-excel";
            httpRenponse.BinaryWrite(buff);

httpRenponse.Flush();

httpRenponse.Close();

httpRenponse.End();
}