最近做了一些导出excel的需求:
例如一些设置背景色,设置字体,边框,添加超链接,合并单元格。
1.设置背景色
headStyle.setFillForegroundColor(IndexedColors.LIME.getIndex()); headStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
2.设置字体边框
HSSFFont redFont = workbook.createFont(); //设置字体大小 redFont.setFontHeightInPoints((short) 12); //字体 redFont.setFontName("宋体");
headStyle.setBorderBottom(BorderStyle.THIN);//下边框 headStyle.setBorderLeft(BorderStyle.THIN);//左边框 headStyle.setBorderRight(BorderStyle.THIN);//右边框 headStyle.setBorderTop(BorderStyle.THIN); //上边框 headStyle.setWrapText(true); //自动换行 headStyle.setAlignment(HorizontalAlignment.CENTER);//水平居中 headStyle.setVerticalAlignment(VerticalAlignment.CENTER);//垂直居中
3.添加超链接
HSSFCell cell = row.createCell(0);//创建单元格 String sheetName = "测试"; sheetName = "#" + sheetName + "!A1";//跳转到指定sheet名称的A1单元格 String value = "11";//单元格显示的值 cell1.setCellFormula("HYPERLINK(\"" + sheetName + "\",\"" + value + "\")");
4.合并单元格
CellRangeAddress region1 = new CellRangeAddress(4, // first row 4, // last row 2, // first column 4 // last column ); sheet.addMergedRegion(region1);