Apache-POI 设置excel单元格样式字体等

大概思路就是设置样式以及字体后添加进单元格中

Workbook wb = new XSSFWorkbook();

Sheet sheet = wb.getSheetAt(0);//创建单元格Row row = sheet.getRow(0);if(null == row){row = sheet.createRow(0);}Cell cell = row.getCell(0);if(null == cell) {cell = row.createCell(0);}//创建样式CellStyle style = wb.createCellStyle();//自动换行style.setWrapText(true);//水平对齐方式（居中）style.setAlignment(HorizontalAlignment.CENTER);//垂直对齐方式（居中）style.setVerticalAlignment(VerticalAlignment.CENTER);//创建字体设置Font baseFont = wb.createFont();//字体baseFont.setFontName("宋体");//大小baseFont.setFontHeightInPoints((short)12);style.setFont(baseFont);//将样式设置应用具体单元格cell.setCellStyle(style);