NPOI设置Excel单元格字体、边框、对齐、背景色

最新推荐文章于 2024-10-23 19:43:38 发布

weixin_34217773

最新推荐文章于 2024-10-23 19:43:38 发布

阅读量694

点赞数

CC 4.0 BY-SA版权

文章标签： c#

原文链接：http://www.cnblogs.com/s0611163/p/7337747.html

本文介绍如何使用NPOI库在Excel中创建并设置单元格样式，包括边框、字体大小及加粗效果，并演示了如何设置单元格背景颜色。

代码：

ICellStyle cellStyle = workbook.CreateCellStyle();
cellStyle.BorderBottom = BorderStyle.Thin;
cellStyle.BorderLeft = BorderStyle.Thin;
cellStyle.BorderRight = BorderStyle.Thin;
cellStyle.BorderTop = BorderStyle.Thin;
cellStyle.VerticalAlignment = NPOI.SS.UserModel.VerticalAlignment.Center;
cellStyle.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center;

ICellStyle cellStyleTitle = workbook.CreateCellStyle();
cellStyleTitle.BorderBottom = BorderStyle.Thin;
cellStyleTitle.BorderLeft = BorderStyle.Thin;
cellStyleTitle.BorderRight = BorderStyle.Thin;
cellStyleTitle.BorderTop = BorderStyle.Thin;
cellStyleTitle.VerticalAlignment = NPOI.SS.UserModel.VerticalAlignment.Center;
cellStyleTitle.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center;
IFont font = workbook.CreateFont();
font.IsBold = false;
font.FontHeightInPoints = 12;
cellStyleTitle.SetFont(font);
HSSFPalette palette = ((HSSFWorkbook)workbook).GetCustomPalette();
palette.SetColorAtIndex((short)9, 98, 185, 106);
var color = palette.FindColor(98, 185, 106);
//下面两行设置单元格背景色
cellStyleTitle.FillPattern = FillPattern.SolidForeground;
cellStyleTitle.FillForegroundColor = color.Indexed;

ICellStyle cellStyleTitle2 = workbook.CreateCellStyle();
cellStyleTitle2.CloneStyleFrom(cellStyleTitle);
font = workbook.CreateFont();
font.IsBold = false;
font.FontHeightInPoints = 14;
cellStyleTitle2.SetFont(font);