ASP.NET NPOI HSSFWorkbook合并单元格、设置单元格格式

最新推荐文章于 2023-01-30 17:57:26 发布

Reforn

最新推荐文章于 2023-01-30 17:57:26 发布

阅读量3.3k

点赞数

分类专栏： C#/ASP.NET/数据库

本文链接：https://blog.csdn.net/Reforn/article/details/80320898

版权

C#/ASP.NET/数据库专栏收录该内容

41 篇文章 1 订阅

订阅专栏

ICellStyle MergeCellstyle = workbook.CreateCellStyle();
MergeCellstyle.VerticalAlignment = VerticalAlignment.Center;
MergeCellstyle.Alignment = HorizontalAlignment.Center;
MergeCellstyle.BorderBottom = BorderStyle.Thin;
MergeCellstyle.BorderLeft = BorderStyle.Thin;
MergeCellstyle.BorderRight = BorderStyle.Thin;
MergeCellstyle.BorderTop = BorderStyle.Thin;

int iFromLine = 2;
int iToLine = 0;

int iCnt = 0;

for (int i = 0; i < dtResult.Rows.Count; i++)
{
int.TryParse(dtResult.Rows[i]["cntPlat"].ToString(), out iCnt);
if (iCnt != 0)
{
iToLine = iCnt + iFromLine - 1;
//sheet = mergeCell(sheet, iFromLine, iToLine, 0, 0);
sheet.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(iFromLine, iToLine, 0, 0));

//设置合并后style
var cell = sheet.GetRow(iFromLine).GetCell(0);
cell.CellStyle = MergeCellstyle;

iFromLine += iCnt;

}
}