Question

java 导入EXCEL表格 单元格合并的情况怎么处理,数据放在哪里?

Answer 1

HSSFWorkbook
wb
=
new
HSSFWorkbook(fis);
HSSFSheet
sheet
=
wb.getSheetAt(0);
HSSFRow
row
=
sheet.getRow(1);
HSSFRow
rowm
=
sheet.getRow(83);//取第84行，读出C84备注，合并单元数据，再写入备注
rowm.setHeight((short)1000);
//合并单元数据
sheet.addMergedRegion(new
Region((short)83
,
(short)
2,
(short)83,
(short)16));