java导出excel合并单元格.docx

@RequestMapping(exportWells) public View exportWells(Model model, HttpServletRequest request) { View view = new AbstractExcelView() { @Override protected void buildExcelDocument(MapString, Object model, HSSFWorkbook workbook, HttpServletRequest request, HttpServletResponse response) throws Exception { // 设置response方式,使执行此controller时候自动出现下载页面,而非直接使用excel打开 response.reset(); response.setContentType(application/vnd.ms-excel); String filename = getFileName() .xls; // 注意，如果去掉下面一行代码中的attachment; 那么也会使IE自动打开文件。 response.setHeader(Content-disposition, attachment;filename= filename); String boardId_aod = request.getParameter(boardId_aod); // 建立 Sheet HSSFSheet sheet = workbook.createSheet(sheet1); int rowNum = 0; int idx = 0; // 建立标题 HSSFRow header = sheet.createRow(rowNum ); HSSFCellStyle cellStyle = workbook.createCellStyle(); HSSFCellStyle centerCellStyle = workbook.createCellStyle(); centerCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); centerCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); centerCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); centerCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); centerCellStyle .setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);// 指定单元格垂直居中对齐 cellStyle.setWrapText(true); cellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); cellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); cellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); cellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); HSSFCellStyle boldCellStyle = workbook.createCellStyle(); boldCellStyle.setWrapText(true); boldCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); boldCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); boldCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); boldCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); HSSFFont font = workbook.createFont(); font.setBoldweight(HSSFFon