NPOI方式导出Excel表头

最新推荐文章于 2024-05-21 11:45:33 发布

DayDay_Code

最新推荐文章于 2024-05-21 11:45:33 发布

阅读量3.9k

点赞数 1

分类专栏： C# 文章标签： C# Excel导出

本文链接：https://blog.csdn.net/CommandBaby/article/details/21370823

版权

C# 专栏收录该内容

30 篇文章 0 订阅

订阅专栏

需要下载NPOI.dll

下载地址：点击打开链接

public void Batch_Update()
          {
            HSSFWorkbook hwb = new HSSFWorkbook();
            MemoryStream ms = new MemoryStream();
            Sheet sheet = hwb.CreateSheet();//默认是sheet0

            Row row1 = sheet.CreateRow(0);
            Cell cell = row1.CreateCell(0);
            cell.SetCellValue("上海XXXX发展有限公司");
            sheet.AddMergedRegion(new CellRangeAddress(0, 0, 0, 21));//合并列  该方法的参数次序是：开始行号，结束行号，开始列号，结束列号。
            row1.Height = 30 * 30; //行高

            cell.CellStyle = HeadStyle(hwb);

            Row row2 = sheet.CreateRow(1);
            Cell cell2 = row2.CreateCell(0);
            cell2.SetCellValue("XX市XX区XX路XX号XX楼X-XX  \r\n TEL：9876543210  FAX：123456");
            sheet.AddMergedRegion(new CellRangeAddress(1, 1, 0, 21));
            row2.Height = 30 * 30;
            cell2.CellStyle = Sub_HeadStyle(hwb);
            sheet.SetColumnWidth(0, 16 * 256);
            hwb.Write(ms);
            Response.AddHeader("Content-Disposition", string.Format("attachment; filename=导出.xls"));
            Response.BinaryWrite(ms.ToArray());
            hwb = null;
            ms.Close(); ms.Dispose();
        }
        /// <summary>
        /// 大标题
        /// </summary>
        /// <param name="hwb"></param>
        /// <returns></returns>
        public CellStyle HeadStyle(HSSFWorkbook hwb)
        {
            CellStyle tstyle = hwb.CreateCellStyle();
            tstyle.Alignment = HorizontalAlignment.CENTER;
            tstyle.VerticalAlignment = VerticalAlignment.CENTER;
            Font tfont = hwb.CreateFont();
            tfont.FontHeight = 22 * 22;
            tfont.FontName = "华文行楷";
            tfont.Color = HSSFColor.RED.index;
            tfont.Boldweight = short.MaxValue;
            tstyle.SetFont(tfont);
            return tstyle;
        }

        /// <summary>
        /// 副标题
        /// </summary>
        /// <param name="hwb"></param>
        /// <returns></returns>
        public CellStyle Sub_HeadStyle(HSSFWorkbook hwb)
        {
            CellStyle cstyle = hwb.CreateCellStyle();
            cstyle.Alignment = HorizontalAlignment.CENTER;
            cstyle.VerticalAlignment = VerticalAlignment.CENTER;
            Font cfont = hwb.CreateFont();
            cstyle.WrapText = true; // 换行 要配合\n使用
            cfont.FontHeight = 15 * 15;
            cfont.FontName = "微软雅黑";
            cfont.Boldweight = short.MaxValue;
            cstyle.SetFont(cfont);
            return cstyle;
        }