在Java中使用easyexcel设置边框线,可以通过StyleStrategy
和WriteCellStyle
来实现。
首先,创建一个自定义的StyleStrategy
,实现org.apache.poi.ss.usermodel.StyleStrategy
接口:
public class CustomStyleStrategy implements StyleStrategy {
@Override
public void registerStyles(Workbook workbook) {
CellStyle cellStyle = workbook.createCellStyle();
cellStyle.setBorderTop(BorderStyle.THIN);
cellStyle.setBorderBottom(BorderStyle.THIN);
cellStyle.setBorderLeft(BorderStyle.THIN);
cellStyle.setBorderRight(BorderStyle.THIN);
cellStyle.setTopBorderColor(IndexedColors.BLACK.getIndex());
cellStyle.setBottomBorderColor(IndexedColors.BLACK.getIndex());
cellStyle.setLeftBorderColor(IndexedColors.BLACK.getIndex());
cellStyle.setRightBorderColor(IndexedColors.BLACK.getIndex());
CellStyle headerStyle = workbook.createCellStyle();
headerStyle.cloneStyleFrom(cellStyle);
headerStyle.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex());
headerStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
// 注册样式
CellStyleUtil.putCellStyle(workbook, cellStyle, true);
CellStyleUtil.putCellStyle(workbook, headerStyle, true);
}
}
然后在写入Excel时,使用WriteCellStyle
将边框样式应用到指定的单元格:
// 创建WriteCellStyle对象,并设置边框样式
WriteCellStyle cellStyle = new WriteCellStyle();
cellStyle.setBorderTop(BorderStyle.THIN);
cellStyle.setBorderBottom(BorderStyle.THIN);
cellStyle.setBorderLeft(BorderStyle.THIN);
cellStyle.setBorderRight(BorderStyle.THIN);
cellStyle.setTopBorderColor(IndexedColors.BLACK.getIndex());
cellStyle.setBottomBorderColor(IndexedColors.BLACK.getIndex());
cellStyle.setLeftBorderColor(IndexedColors.BLACK.getIndex());
cellStyle.setRightBorderColor(IndexedColors.BLACK.getIndex());
// 设置边框样式
EasyExcel.write(fileName, Data.class)
.registerWriteHandler(new HorizontalCellStyleStrategy(new CustomStyleStrategy()))
.write(data, EasyExcel.writerSheet(sheetName).build());
通过以上步骤,就可以在Java中使用easyexcel设置边框线了。
版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,请发送邮件至 55@qq.com 举报,一经查实,本站将立刻删除。转转请注明出处:https://www.szhjjp.com/n/829769.html