1.给指定行指定列设置字体及居中
private void setFontAlign(Workbook workbook,int rowIndex,int columnIndex){
Sheet sheet = workbook.getSheet("sheet1");
CellStyle cellStyle = workbook.createCellStyle();
Font font = workbook.createFont();
font.setBold(true);
cellStyle.setFont(font);
cellStyle.setAlignment(HorizontalAlignment.CENTER);
cellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
Row row = sheet.getRow(rowIndex);
Cell cell = row.getCell(columnIndex);
cell.setCellStyle(cellStyle);
}
2.给指定行指定列设置边框
private void setBorder(Workbook workbook,int rowIndex,int columnIndex){
Sheet sheet = workbook.getSheet("sheet1");
CellStyle cellStyle = workbook.createCellStyle();
cellStyle.setAlignment(HorizontalAlignment.CENTER);
cellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
cellStyle.setBorderBottom(BorderStyle.THIN);
cellStyle.setBorderLeft(BorderStyle.THIN);
cellStyle.setBorderRight(BorderStyle.THIN);
cellStyle.setBorderTop(BorderStyle.THIN);
Row row = sheet.getRow(rowIndex);
Cell cell = row.getCell(columnIndex);
cell.setCellStyle(cellStyle);
}