java hutool 导出excel 合并单元格

package pdf;


import lombok.Data;


import java.math.BigDecimal;

@Data
public class VerifyPlatform {
	private static final long serialVersionUID = 1L;

	/**
	 * 客户编码
	 */
	private String ccustomeridcode;
	/**
	 * 客户名称
	 */
	private String ccustomeridname;
	/**
	 * 应收千斤坛
	 */
	private BigDecimal receivejar;
	/**
	 * 应收标准瓶
	 */
	private BigDecimal receivestandard;
	/**
	 * 应收合计
	 */
	private BigDecimal receivesum;
	/**
	 * 逾期千斤坛
	 */
	private BigDecimal overduejar;
	/**
	 * 逾期标准瓶
	 */
	private BigDecimal overduestandard;
	/**
	 * 逾期合计
	 */
	private BigDecimal overduesum;

}

@Test
    public void test1(){
        //定义基础数据
        List<pdf.VerifyPlatform> verifyPlatforms = new ArrayList<>();
        pdf.VerifyPlatform verifyPlatform = new pdf.VerifyPlatform();
        verifyPlatform.setCcustomeridcode("00001");
        verifyPlatform.setCcustomeridname("北京百a小公司");
        verifyPlatform.setReceivesum(new BigDecimal("100"));
        verifyPlatform.setReceivestandard(new BigDecimal("80"));
        verifyPlatform.setReceivejar(new BigDecimal("20"));
        verifyPlatform.setOverduesum(new BigDecimal("212345678.90"));
        verifyPlatform.setOverduestandard(new BigDecimal("199"));
        verifyPlatform.setOverduejar(new BigDecimal("1"));
        verifyPlatform.setOccupancymny(new BigDecimal("50"));
        for (int i = 0; i < 4; i++) {
            if (i == 0) {
                pdf.VerifyPlatform verifyPlatform1 = new VerifyPlatform();
                CglibUtil.copy(verifyPlatform, verifyPlatform1);
                verifyPlatform1.setReceivesum(new BigDecimal("0"));
                verifyPlatforms.add(verifyPlatform1);
            } else {
                verifyPlatforms.add(verifyPlatform);
            }

        }
        ExcelWriter writer = ExcelUtil.getBigWriter();
        writer.merge(0, 1,  0, 0, "客户编码", true);
        writer.merge(0, 1,  1, 1, "客户名称", true);
        writer.merge(0, 0,  2, 4, "剩余应收情况", true);
        writer.merge(0, 0,  5, 7, "订单逾期情况", true);
        writer.merge(0, 1,  8, 8, "资金占用费", true);

        writer.addHeaderAlias("ccustomeridcode", "客户编码");
        writer.addHeaderAlias("ccustomeridname", "客户名称");
        writer.addHeaderAlias("receivesum", "剩余应收合计");
        writer.addHeaderAlias("receivestandard", "标准瓶剩余应收");
        writer.addHeaderAlias("receivejar", "千斤坛剩余应收");
        writer.addHeaderAlias("overduesum", "订单逾期合计");
        writer.addHeaderAlias("overduestandard", "标准瓶逾期金额");
        writer.addHeaderAlias("overduejar", "千斤坛逾期");
        writer.addHeaderAlias("occupancymny", "资金占用费");

        writer.setOnlyAlias(true);
        writer.passCurrentRow();

        //导出数据
        // 一次性写出内容，使用默认样式，强制输出标题
        writer.write(verifyPlatforms, true);
        writer.flush(new File("E:\\www\\java\\study\\_2020\\target\\template1.xls"));
        writer.close();

    }