使用jxl生成Excel，带有合并标题

直接上代码    不明白可以留言

public void exportList() throws Exception{List<String> title=new ArrayList<String>();title.add("序号");title.add("地区");title.add("项目名称");title.add("项目建设目标和主要建设内容");title.add("申请单位情况");title.add("");title.add("");title.add("");title.add("");title.add("企业知识产权情况");title.add("");title.add("");title.add("企业2018年经济效益（万元）");title.add("");title.add("");title.add("");title.add("项目经费（万元）");title.add("");title.add("");title.add("");title.add("项目技术设备投资总额（万元）");title.add("");title.add("项目预期新增自主创新成果");title.add("");title.add("");title.add("项目预期新增经济效益（万元）");title.add("");title.add("");title.add("项目起止年月");List<String> titles=new ArrayList<String>();titles.add("");titles.add("");titles.add("");titles.add("");titles.add("企业名称");titles.add("所属新兴产业");titles.add("组织机构代码");titles.add("技术中心级别");titles.add("是否在国家级或省级新型工业化产业示范基地内");titles.add("拥有授权专利数");titles.add("其中：拥有授权发明专利数");titles.add("申请专利数");titles.add("销售收入");titles.add("研发投入");titles.add("税金");titles.add("利润");titles.add("总投资");titles.add("自筹");titles.add("贷款");titles.add("申请财政补助");titles.add("技术设备购置总额");titles.add("2018年1月1日至2018年12月31日技术设备购置额");titles.add("项目预期形成专利数");titles.add("项目预期形成发明专利数");titles.add("项目预计开发新产品（新技术）数量");titles.add("销售收入");titles.add("税金");titles.add("利润");titles.add("");WritableWorkbook workbook = null;WritableSheet worksheet = null;Label label = null;String targetFile="D:/upload/fdacis/export/exportExcel.xls";String sheet="企业创新能力汇总";checkFile(targetFile);OutputStream os = new FileOutputStream(targetFile);workbook = Workbook.createWorkbook(os);worksheet = workbook.createSheet(sheet, 0);//设置列宽worksheet.setColumnView(1,12);worksheet.setColumnView(2,15);worksheet.setColumnView(3,20);//列  宽度worksheet.setColumnView(4,15);worksheet.setColumnView(5,12);worksheet.setColumnView(6,15);worksheet.setColumnView(7,12);worksheet.setColumnView(8,22);worksheet.setColumnView(10,13);worksheet.setColumnView(12,12);worksheet.setColumnView(19,12);worksheet.setColumnView(20,17);worksheet.setColumnView(21,22);worksheet.setColumnView(22,12);worksheet.setColumnView(23,13);worksheet.setColumnView(24,17);worksheet.setColumnView(28,16);//设置行高worksheet.setRowView(0,670);worksheet.setRowView(1,1200);//设置样式WritableFont wfont=new WritableFont(WritableFont.ARIAL,12);WritableCellFormat titleFormat = new WritableCellFormat(wfont);titleFormat.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);   //设置垂直居中titleFormat.setAlignment(jxl.format.Alignment.CENTRE);//设置文字居中对齐方式titleFormat.setBorder(Border.ALL, BorderLineStyle.THIN);//设置边框,dashed虚线，THIN实线，dotted虚线,double双实线titleFormat.setWrap(true);//自动换行//titleFormat.setBackground(jxl.format.Colour.GREY_25_PERCENT);//单元格背景色//合并单元格//mergeCells(a,b,c,d) 单元格合并函数//a 单元格的列号//b 单元格的行号//c 从单元格[a,b]起，向左合并到c列//d 从单元格[a,b]起，向下合并到d行worksheet.mergeCells(0,0,0,1);worksheet.mergeCells(1,0,0,1);worksheet.mergeCells(2,0,0,1);worksheet.mergeCells(3,0,0,1);worksheet.mergeCells(4,0,8,0);worksheet.mergeCells(9,0,11,0);worksheet.mergeCells(12,0,15,0);worksheet.mergeCells(16,0,19,0);worksheet.mergeCells(20,0,21,0);worksheet.mergeCells(22,0,24,0);worksheet.mergeCells(25,0,27,0);worksheet.mergeCells(28,0,0,1);// title startfor (int i = 0; i < title.size(); i++) {label = new Label(i, 0, title.get(i),titleFormat);// 列 行 内容worksheet.addCell(label);}// title startfor (int i = 0; i < titles.size(); i++) {label = new Label(i, 1, titles.get(i),titleFormat);// 列 行 内容worksheet.addCell(label);}//content startfor (int i = 0; i < exportList.size(); i++) {Map<String,Object> map=exportList.get(i);worksheet.addCell(new Label(0, i+2,String.valueOf(i+1),titleFormat));// 列 行 内容worksheet.addCell(new Label(1, i+2,isNull(map.get("dq")),titleFormat));worksheet.addCell(new Label(2, i+2,isNull(map.get("xmmc")),titleFormat));worksheet.addCell(new Label(3, i+2,isNull(map.get("xmjnr")),titleFormat));worksheet.addCell(new Label(4, i+2,isNull(map.get("qymc")),titleFormat));worksheet.addCell(new Label(5, i+2,isNull(map.get("sscy")),titleFormat));worksheet.addCell(new Label(6, i+2,isNull(map.get("zzjgdm")),titleFormat));worksheet.addCell(new Label(7, i+2,isNull(map.get("qyjszxjb1")),titleFormat));worksheet.addCell(new Label(8, i+2,isNull(map.get("sfsfjd")),titleFormat));worksheet.addCell(new Label(9, i+2,isNull(map.get("yysqzls")),titleFormat));worksheet.addCell(new Label(10, i+2,isNull(map.get("fmzls")),titleFormat));worksheet.addCell(new Label(11, i+2,isNull(map.get("sqzls")),titleFormat));worksheet.addCell(new Label(12, i+2,isNull(map.get("xssr")),titleFormat));worksheet.addCell(new Label(13, i+2,isNull(map.get("yfjftr")),titleFormat));worksheet.addCell(new Label(14, i+2,isNull(map.get("sj")),titleFormat));worksheet.addCell(new Label(15, i+2,isNull(map.get("lr")),titleFormat));worksheet.addCell(new Label(16, i+2,isNull(map.get("xmztz")),titleFormat));worksheet.addCell(new Label(17, i+2,isNull(map.get("zczj")),titleFormat));worksheet.addCell(new Label(18, i+2,isNull(map.get("yhdk")),titleFormat));worksheet.addCell(new Label(19, i+2,isNull(map.get("sqczbz")),titleFormat));worksheet.addCell(new Label(20, i+2,isNull(map.get("jssbgzze")),titleFormat));worksheet.addCell(new Label(21, i+2,isNull(map.get("qzgze")),titleFormat));worksheet.addCell(new Label(22, i+2,isNull(map.get("xmyqxczls")),titleFormat));worksheet.addCell(new Label(23, i+2,isNull(map.get("yqfmzls")),titleFormat));worksheet.addCell(new Label(24, i+2,isNull(map.get("yqxcxcp")),titleFormat));worksheet.addCell(new Label(25, i+2,isNull(map.get("xzxssr")),titleFormat));worksheet.addCell(new Label(26, i+2,isNull(map.get("xzsj")),titleFormat));worksheet.addCell(new Label(27, i+2,isNull(map.get("xzlr")),titleFormat));worksheet.addCell(new Label(28, i+2,isNull(map.get("qssj")),titleFormat));}workbook.write();workbook.close();os.close();
}

/*** 检查文件是否存在，存在则删除*/
public  void checkFile(String target) {String path = target.substring(0,target.lastIndexOf("/"));checkDir(path);File file = new File(target);if (file.exists()) {file.delete();}
}