java导出excel含合并单元格.docVIP

java导出excel含合并单元格 List sgwlList=sgwlService.getSgwlList(pageModel,province,city,countyid); //集合 try { OutputStream os = response.getOutputStream();// 取得输出流 response.reset();// 清空输出流 String tmptitle = 按省干网络查询; // 标题 response.setHeader(Content-disposition, attachment; filename=+new String(tmptitle.getBytes(),iso8859-1)+.xls);// 设定输出文件头 response.setContentType(application/vnd.ms-excel);// 定义输出类型 WritableWorkbook wbook = Workbook.createWorkbook(os); // 建立excel文件 WritableSheet wsheet = wbook.createSheet(tmptitle, 0); // sheet名称 // 设置excel标题 WritableFont wfont = new WritableFont(WritableFont.ARIAL, 16,WritableFont.BOLD,false,UnderlineStyle.NO_UNDERLINE,Colour.BLACK); WritableCellFormat wcfFC = new WritableCellFormat(wfont); wcfFC.setBackground(Colour.AQUA); wsheet.addCell(new Label(1, 0, tmptitle, wcfFC)); wsheet.mergeCells(1, 0, 4, 0); wfont = new jxl.write.WritableFont(WritableFont.ARIAL, 14,WritableFont.BOLD,false, UnderlineStyle.NO_UNDERLINE,Colour.BLACK); wcfFC = new WritableCellFormat(wfont); wsheet.mergeCells(0, 2, 0, 3); //序列 wsheet.mergeCells(1, 2, 1, 3); //运营机构名称 wsheet.mergeCells(2, 2, 6, 2); //干线网络类型 wsheet.mergeCells(7, 2, 7, 3); //干线最高速率 wsheet.mergeCells(8, 2, 8, 3); //OTN波长数量 wsheet.mergeCells(9, 2, 9, 3); //DWDM波长数量 wsheet.mergeCells(10, 2, 10, 3); //OTN实际使用波长数量 wsheet.mergeCells(11, 2, 11, 3); //DWDM实际使用波长数量 wsheet.mergeCells(12, 2, 13, 2); //中继站个数 wsheet.mergeCells(14, 2, 14, 3); //年不可用时间(h) wsheet.mergeCells(15, 2, 15, 3); //年光缆中断时间(h) wsheet.mergeCells(16, 2, 16, 3); //统一网管 wsheet.mergeCells(17, 2, 18, 2); //故障响应时间(h) wsheet.mergeCells(19, 2, 20, 2); //故障恢复时间(h) wsheet.mergeCells(21, 2, 21, 3); //填报时间 // 开始生成主体内容 wsheet.addCell(new Label(0, 2, 序号,wcfFC)); wsheet.addCell(new Label(1, 2, 运营机构名称,wcfFC)); wsheet.ad