Excel操作

1.创建

SXSSFWorkbook workbook = new SXSSFWorkbook();
SXSSFSheet sheet = workbook.createSheet("test");

2.设置宽度

sheet.setColumnWidth(1, 50 * 256);

3.换行

XSSFCellStyle style = workbook.getXSSFWorkbook().createCellStyle();
style.setWrapText(true);

4.合并行

CellRangeAddress cellRangeAddress = new CellRangeAddress(0, 1, 0, 1, 2);
sheet.addMergedRegionUnsafe(cellRangeAddress);

5.设置对齐

style.setAlignment(HorizontalAlignment.CENTER);
style.setVerticalAlignment(VerticalAlignment.CENTER);

6.创建字体样式

 XSSFFont titleFont = workbook.getXSSFWorkbook().createFont();

7.设置字体加粗

titleFont.setBold(true);

8.设置字体颜色

titleFont.setColor(new XSSFColor(new java.awt.Color(47, 117, 181)));
style.setFont(titleFont);