一、说明
1、此poi指org.apache.poi
2、maven依赖的版本
<dependency><groupId>org.apache.poi</groupId><artifactId>poi-ooxml</artifactId><version>4.1.2</version></dependency>说明1: 不同的版本,操作的类的方式不太一样
二、常用操作
1、设置字体颜色
1)代码
Workbook wb = new SXSSFWorkbook();Font headerFont = wb.createFont();headerFont.setColor(IndexedColors.WHITE.getIndex());
2、设置单元格背景颜色
1)代码
Workbook wb = new SXSSFWorkbook();CellStyle cellStyle = wb.createCellStyle();cellStyle.setFillForegroundColor(IndexedColors.SEA_GREEN.getIndex());cellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);说明: cellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND); 必须设置
3、设置边框
1)代码
Workbook wb = new SXSSFWorkbook();CellStyle cellStyle = wb.createCellStyle();cellStyle.setBorderBottom(BorderStyle.THIN);cellStyle.setBorderLeft(BorderStyle.THIN);cellStyle.setBorderRight(BorderStyle.THIN);cellStyle.setBorderTop(BorderStyle.THIN);说明: 上下左右,需要分别设置
4、自动换行
1)代码
Workbook wb = new SXSSFWorkbook();CellStyle cellStyle = wb.createCellStyle();cellStyle.setWrapText(true);
5、设置字体,设置行宽,设置列高
1)代码
Workbook wb = new SXSSFWorkbook();CellStyle cellStyle = wb.createCellStyle();// 创建字体Font font = wb.createFont();// 宋体contentFont.setFontName("宋体");// 字号:11contentFont.setFontHeightInPoints((short)11);// 加粗contentFont.setBold(true);cellStyle.setFont(font);// 创建sheetSheet sheet = wb.createSheet("sheet1");// 设置列宽// 第1列,12个字符sheet.setColumnWidth(0, 12 * 256);sheet.setColumnWidth(1, 12 * 256);// 第3列,42个字符sheet.setColumnWidth(2, 42 * 256);// 创建行Row row = sheet.createRow(0);// 设置行高row.setHeight((short)(48 * 20));// 创建单元格Cell cell = row.createCell(0);// 设置格式cell.setCellStyle(cellStyle);// 设值cell.setCellValue(val);
6、合并单元格
1)代码
Workbook wb = new SXSSFWorkbook();// 创建sheetSheet sheet = wb.createSheet("sheet1");// 合并单元格// 合并第9行的第一列与第二列// 参数理解: 从第9行到第9行,从第1列到第2列CellRangeAddress region = new CellRangeAddress(8, 8, 0, 1);sheet.addMergedRegion(region);workbookSheet.addMergedRegion(new CellRangeAddress(1, 4, 0, 0));// 1tworkbookSheet.addMergedRegion(new CellRangeAddress(1, 4, 1, 1));// 1workbookSheet.addMergedRegion(new CellRangeAddress(1, 4, 2, 2));// 1workbookSheet.addMergedRegion(new CellRangeAddress(1, 4, 3, 3));// 1workbookSheet.addMergedRegion(new CellRangeAddress(1, 4, 4, 4));// 1workbookSheet.addMergedRegion(new CellRangeAddress(1, 4, 5, 5));//1workbookSheet.addMergedRegion(new CellRangeAddress(1, 2, 6, 14));// 占9列 6-14workbookSheet.addMergedRegion(new CellRangeAddress(1, 1, 15, 35));// 占21列 初始15列-结束列35workbookSheet.addMergedRegion(new CellRangeAddress(1, 1, 36, 56));// 占21列 初始36列-结束列56workbookSheet.addMergedRegion(new CellRangeAddress(1, 1, 57, 77));// 占21列 初始57列-结束列77
如果觉得《【java中poi导出excel操作设置复杂表头设置单元格格式背景颜色自动换行】》对你有帮助,请点赞、收藏,并留下你的观点哦!