求教,C#导出Excel时设置列宽和边框

2025-03-26 13:19:42
推荐回答(2个)
回答1:

XSSFWorkbook xssfworkbook = new XSSFWorkbook();
ICellStyle cellStyle = xssfworkbook.CreateCellStyle();
cellStyle.BorderBottom = NPOI.SS.UserModel.BorderStyle.THIN;
cellStyle.BorderLeft = NPOI.SS.UserModel.BorderStyle.THIN;
cellStyle.BorderRight = NPOI.SS.UserModel.BorderStyle.THIN;
cellStyle.BorderTop = NPOI.SS.UserModel.BorderStyle.THIN;
ISheet sheet = xssfworkbook.CreateSheet(name);
sheet.SetColumnWidth(0, 10 * 256);(第1列)
sheet.SetColumnWidth(1, 10 * 256);(第2列)
......................................................

回答2:

就是这样设置