java excel 导出 单元格合并_java导出excel合并单元格.docx

@RequestMapping("exportWells")

public View exportWells(Model model, HttpServletRequest request) {

View view = new AbstractExcelView() {

@Override

protected void buildExcelDocument(Map 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.setBo