合并单元格的方法
2021
04.14

合并单元格的方法: 

sheet.addMergedRegion("起始行", "起始列", "终止行", "终止列");

合并示例:

//表头信息

HSSFRow row1= sheet.createRow(0);

cell = row1.createCell((short) 0);

cell.setCellValue("");

sheet.addMergedRegion(new Region((short)0, (short) 0, (short)0, (short) 0));

cell = row1.createCell((short) 1); cell.setCellValue("时间");

sheet.addMergedRegion(new Region((short)0, (short) 1, (short)0, (short) 2));



HSSFRow row2= sheet.createRow(1);

cell = row2.createCell((short) 0);

cell.setCellValue("序号");

sheet.addMergedRegion(new Region((short)1, (short) 0, (short)1, (short) 0));

cell = row2.createCell((short) 1); cell.setCellValue("起始时间");

sheet.addMergedRegion(new Region((short)1, (short) 1, (short)1, (short) 1));

cell = row2.createCell((short) 2); cell.setCellValue("终止时间");

sheet.addMergedRegion(new Region((short)1, (short) 2, (short)1, (short) 2));



 

运行结果,得到的 Excel 表如下所示: 

 

 

 

文件样式可在导出后自行添加


热门文章
1
通过微信接口获取code
7084浏览 2021-04-14 09:26
2
Java实现html页面抓取转PDF
4040浏览 2021-04-13 17:09
3
vue 页面按钮点击复制内容
2987浏览 2021-04-21 09:42
4
对接父子级数据的添加或修改逻辑
2948浏览 2021-04-21 09:47
5
Mysql常用sql语句
2754浏览 2021-04-20 10:46
6
邀请函│EICD2021中国民办教育大会
2062浏览 2021-03-15 14:06
7
Linux安装中文字体
1980浏览 2021-04-13 17:14
8
合并单元格的方法
1697浏览 2021-04-14 09:23
9
vue中数组去重的实现
1606浏览 2021-04-14 09:20
10
Nginx如何配置重定向
1578浏览 2021-04-14 09:09