一、合并单元格
CellRangeAddress rangeAddress = new CellRangeAddress(1, 1, 2, 6);
sxssfSheet.addMergedRegion(rangeAddress);
行下标、列下标均从0开始。注意:合并之前行列数应该是一致的,如果不足可以以空格来补齐。
如:
String[] headersFirstLine = new String[]{"基础信息","",""};
String[] headersSecondLine = new String[]{"姓名","年龄","住址"};
CellRangeAddress rangeAddress = new CellRangeAddress(0, 1, 0, 2);
sxssfSheet.addMergedRegion(rangeAddress);