POI一些设置
POI一些设置
## 创建HSSFWorkbook
HSSFWorkbook workbook = new HSSFWorkbook();
## 创建HSSFSheet
HSSFSheet sheet = workbook.createSheet("sheetName");
## cell样式
HSSFCellStyle cellStyle = wb.createCellStyle();
//设置边框
cellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); //下边框
cellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); //左边框
cellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); //上边框
cellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); //右边框
//设置居中
cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 居中
cellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);//垂直居中
## 为每个cell设值和设置cellStyle
for (int k=0; k < columnKeys.length; k++){
String value = getHeaderValue(columnKeys[k]);
cell = row.createCell(k);
cell.setCellStyle(cellStyle);
cell.setCellValue(new HSSFRichTextString(value));
}
## 合并单元格,必须在cell设值之后被执行
CellRangeAddress cra = new CellRangeAddress(i-row,i, k,k); //参数: (fromRow,toRow, fromCol, toCol)
sheet.addMergedRegion(cra);
RegionUtil.setBorderBottom(1, cra, sheet,workbook); // 下边框
RegionUtil.setBorderLeft(1, cra, sheet,workbook); // 左边框
RegionUtil.setBorderRight(1, cra, sheet,workbook); // 有边框
RegionUtil.setBorderTop(1, cra, sheet,workbook); // 上边框