c#导出EXCEL

最新推荐文章于 2024-01-19 11:06:51 发布

Devin__Yang

最新推荐文章于 2024-01-19 11:06:51 发布

阅读量518

点赞数

分类专栏： .Net 文章标签： excel c#

本文链接：https://blog.youkuaiyun.com/yangding_/article/details/50580062

版权

.Net 专栏收录该内容

6 篇文章

订阅专栏

本文详细介绍了如何使用NPOI库将数据集转换为Excel文件，并通过代码实例展示了从数据表中读取数据并将其写入Excel的过程。

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

using NPOI.HSSF.UserModel;
using Resources;
using System;
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using System.IO;
using System.Text;
using System.Web.UI;
using System.Web.UI.WebControls;
using V5print.BLL.Order;
using NPOI.XWPF.UserModel;
using NPOI.OpenXmlFormats.Wordprocessing;
using System.Web;
private void DataSetToExcel(DataTable data)
        {
            base.Response.Clear();
            using (MemoryStream stream = new MemoryStream())
            {
                string str = DateTime.Now.ToString("yyyy-MM-dd_HHmmss");
                HSSFWorkbook workbook = new HSSFWorkbook();
                HSSFSheet sheet = (HSSFSheet)workbook.CreateSheet(string.Format("导出订单_{0}", str));
                HSSFRow row = (HSSFRow)sheet.CreateRow(0);
                foreach (DataColumn column in data.Columns)
                {
                    row.CreateCell(column.Ordinal).SetCellValue(column.ColumnName);
                }
                int rownum = 1;
                foreach (DataRow row2 in data.Rows)
                {
                    HSSFRow row3 = (HSSFRow)sheet.CreateRow(rownum);
                    foreach (DataColumn column2 in data.Columns)
                    {
                        row3.CreateCell(column2.Ordinal).SetCellValue(row2[column2].ToString());
                    }
                    row3 = null;
                    rownum++;
                }
                for (int i = 0; i < data.Columns.Count; i++)
                {
                    sheet.AutoSizeColumn(i);
                }
                workbook.Write(stream);
                row = null;
                sheet = null;
                workbook = null;
                base.Response.AddHeader("Content-Disposition", string.Format("attachment; filename=ExportOrder_{0}.xls", str));
                base.Response.BinaryWrite(stream.ToArray());
                stream.Close();
                stream.Dispose();
            }
            base.Response.End();
        }