java poi excel2007 如何实现合并行列?

2025-05-14 00:22:06
推荐回答(3个)
回答1:

// 单元格合并
// 四个参数分别是:起始行,起始列,结束行,结束列
sheet.addMergedRegion(new Region(0, (short) (celln + 1), 0,
(short) (celle + 1)));
试试这个呢
sheet.addMergedRegion(new CellRangeAddress(0, 0, startColumn + 3*j, startColumn + 3*j + 2));

回答2:

//arg0 x轴,arg1 y轴,arg2 x长度,arg3 y长度
writableSheet.mergeCells(arg0, arg1, arg2, arg3)

回答3:

addMergedRegion(new Region(行, (short)列, 行, (short)列));