Springboot POI -- Excel格式处理

引入 poi 依赖

  <dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi</artifactId>
      <version>4.1.2</version>
  </dependency>

表格基本属性默认配置

HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet();
//默认单元格宽度
sheet.setDefaultColumnWidth(30);
//默认行高
sheet.setDefaultRowHeight((short)(30*12));

指定某行设置行高

HSSFRow row0 = sheet.createRow(0);
// 设置行高
row0.setHeight(cellHeight);

设置单元格字体

HSSFCell cell = row0.createCell(0);
cell.setCellValue("测试");

HSSFFont columnHeadFont = wb.createFont();
columnHeadFont.setBold(true);//加粗
columnHeadFont.setFontName("宋体");//字体
columnHeadFont.setFontHeight((short) 240);//字体大小
columnHeadFont.setColor((short) 10000);//字体颜色

HSSFCellStyle style= wb.createCellStyle();
style.setFont(columnHeadFont);

cell.setCellStyle(style);

单元格描边黑框

style.setBorderBottom(BorderStyle.THIN); //下边框
style.setBorderLeft(BorderStyle.THIN);//左边框
style.setBorderTop(BorderStyle.THIN);//上边框
style.setBorderRight(BorderStyle.THIN);//右边框

单元格内容居中

style.setVerticalAlignment(VerticalAlignment.CENTER);//垂直居中
style.setAlignment(HorizontalAlignment.CENTER);//水平居中

单元格默认文本格式

HSSFDataFormat format = wb.createDataFormat();
style.setDataFormat(format.getFormat("@"));

指定某列设置默认属性

sheet.setDefaultColumnStyle(0, style);

合并单元格并描边黑框

合并单元格时一定要大于两个单元格，否则会报错
CellRangeAddress(int firstRow, int lastRow, int firstCol, int lastCol)

CellRangeAddress regionCell = new CellRangeAddress(0,0,0,1);
sheet.addMergedRegion(regionCell);
RegionUtil.setBorderTop(BorderStyle.THIN,regionCell,sheet);//上边框
RegionUtil.setBorderBottom(BorderStyle.THIN,regionCell,sheet);//下边框
RegionUtil.setBorderLeft(BorderStyle.THIN,regionCell,sheet);//左边框
RegionUtil.setBorderRight(BorderStyle.THIN,regionCell,sheet);//右边框