关于java生成Excel文件时合并单元格出现的问题

2011-04-15 08:34:26 1.2k 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

java使用poi生成excel 使用poi生成excel通常包含一下几个步骤创建一个工作簿创建一个sheet 创建一个Row对象创建一个cell对象(1个row+1个cell构成一个单元格) 设置单元格内容设置单元格样式. 字体字体大小是否加粗保存关闭流对象生成一个工作簿 2010以上格式使用XSSFWorkBook对象, 2003格式使用HSSFWorkBook对象, 其他对象操作基本一样. 生成2003格式 public void test1() { HSSFWorkbook ... 阅读详情

在用java生成Excel中合并单元格时代码如下：（截取出去Warning的部分）
for (int i = 0; i < 4; i++) {
for (int j = 0; j < 10; j++) {
ws.addCell(new Label(j, i, "标题", center));
}
}
ws.mergeCells(0, 0, 10, 3);// 合并单元格

for (int i = 0; i < 11; i++) {
if (i < 7) {
ws.addCell(new Label(i, 4, "", center));
} else {
ws.addCell(new Label(i, 4, "学位办公室制", center));
}
}
ws.mergeCells(7, 4, 10, 4);
但是会有这样的Warning：
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range A1-K4 contains more than one data cell. Setting the other cells to blank.
Warning: Range H5-K5 contains more than one data cell. Setting the other cells to blank.
Warning: Range H5-K5 contains more than one data cell. Setting the other cells to blank.
Warning: Range H5-K5 contains more than one data cell. Setting the other cells to blank.
求解！！！

...全文

java poi 读取有合并单元格的EXCEL文件数据的样子是这样的报表名称班次生产线站点编号设备区域 1:无;2:左右报表状态0:未启用;1启用检查项目检查方法填报方式标准值偏差值频次 import1 1 LC 52V451 2 1 检查项目1 目测数值 10 1 10 检查项目2 填报 OK/NO 66 6 6 阅读详情

_超级赛亚人_

Java EE 67,535 成员 225,843 内容

+ 关注 + 加入社区

切换为时间正序

_超级赛亚人_ 2011-04-15

打赏
举报

[Quote=引用 5 楼 kai27ks 的回复:]
在用java生成Excel中合并单元格时代码如下：（截取出去Warning的部分）
for (int i = 0; i < 4; i++) {
for (int j = 0; j < 10; j++) {
ws.addCell(new Label(j, i, "标题", center));
}
}
i从0到3，j从0到9.一共也才4*10=40
[/Quote]
恩。。那个是得改成9
但是我刚才试了下。。为什么我在空白Excel里面合并两个单元格的时候也会出现那个警告
怎么在合并之后把覆盖的单元格置成blank

kai27ks 2011-04-15

打赏
举报

在用java生成Excel中合并单元格时代码如下：（截取出去Warning的部分）
for (int i = 0; i < 4; i++) {
for (int j = 0; j < 10; j++) {
ws.addCell(new Label(j, i, "标题", center));
}
}
i从0到3，j从0到9.一共也才4*10=40

kai27ks 2011-04-15

打赏
举报

4行11列？那就是问题所在了。。。你生成的一共才4行10列啊！！

_超级赛亚人_ 2011-04-15

打赏
举报

[Quote=引用 2 楼 kai27ks 的回复:]
警告：有超过一列的数据列，将其它的（未处理的）数据列设置为空。
解释下这句：ws.mergeCells(0, 0, 10, 3);
我好给你检查下。
[/Quote]
将第0列0行对应的单元格到 10列3行对应的单元格合并
也就是说将总共4行行11列的单元格合并

kai27ks 2011-04-15

打赏
举报

警告：有超过一列的数据列，将其它的（未处理的）数据列设置为空。
解释下这句：ws.mergeCells(0, 0, 10, 3);
我好给你检查下。

kai27ks 2011-04-15

打赏
举报

不兼容你的IE版本啊。你查看下插件说明。针对哪些浏览器有效。IE也有分版本的例如IE6,7,8

_超级赛亚人_ 2011-04-15

打赏
举报

[Quote=引用 7 楼 kai27ks 的回复:]
坦白说这个类我没用过。你可以找下它的API
[/Quote]
还是谢谢你哈。。。我重新用POI插件做了。。但是上面的问题还是没解决。。

再有就是：请问下导出（Excel或则dbf文件）我在火狐下都好使，但是在IE下就是不弹出保存框，后台也不报错，请问怎么解决

kai27ks 2011-04-15

打赏
举报

坦白说这个类我没用过。你可以找下它的API

关于java生成Excel文件时合并单元格出现的问题

相关推荐