Examples with LoopMergeStrategy com.alibaba.excel.write.merge.LoopMergeStrategy used on opensource projects

Example 1 with LoopMergeStrategy

use of com.alibaba.excel.write.merge.LoopMergeStrategy in project easyexcel by alibaba.

the class WriteTest method mergeWrite.

/**
 * 合并单元格
 * <p>
 * 1. 创建excel对应的实体对象 参照{@link DemoData} {@link DemoMergeData}
 * <p>
 * 2. 创建一个merge策略 并注册
 * <p>
 * 3. 直接写即可
 *
 * @since 2.2.0-beta1
 */
@Test
public void mergeWrite() {
    // 方法1 注解
    String fileName = TestFileUtil.getPath() + "mergeWrite" + System.currentTimeMillis() + ".xlsx";
    // 在DemoStyleData里面加上ContentLoopMerge注解
    // 这里 需要指定写用哪个class去写，然后写到第一个sheet，名字为模板 然后文件流会自动关闭
    EasyExcel.write(fileName, DemoMergeData.class).sheet("模板").doWrite(data());
    // 方法2 自定义合并单元格策略
    fileName = TestFileUtil.getPath() + "mergeWrite" + System.currentTimeMillis() + ".xlsx";
    // 每隔2行会合并 把eachColumn 设置成 3 也就是我们数据的长度，所以就第一列会合并。当然其他合并策略也可以自己写
    LoopMergeStrategy loopMergeStrategy = new LoopMergeStrategy(2, 0);
    // 这里 需要指定写用哪个class去写，然后写到第一个sheet，名字为模板 然后文件流会自动关闭
    EasyExcel.write(fileName, DemoData.class).registerWriteHandler(loopMergeStrategy).sheet("模板").doWrite(data());
}

Example 2 with LoopMergeStrategy

use of com.alibaba.excel.write.merge.LoopMergeStrategy in project java-example by saxingz.

the class EasyExcelTest method main.

public static void main(String[] args) {
    // 方法1 注解
    String fileName = TestFileUtil.getPath() + "mergeWrite" + System.currentTimeMillis() + ".xlsx";
    // 在DemoStyleData里面加上ContentLoopMerge注解
    // 这里 需要指定写用哪个class去写，然后写到第一个sheet，名字为模板 然后文件流会自动关闭
    // EasyExcel.write(fileName, DemoMergeData.class).sheet("模板").doWrite(data());
    // 方法2 自定义合并单元格策略
    fileName = TestFileUtil.getPath() + "mergeWrite" + System.currentTimeMillis() + ".xlsx";
    // 每隔2行会合并 把eachColumn 设置成 3 也就是我们数据的长度，所以就第一列会合并。当然其他合并策略也可以自己写
    LoopMergeStrategy loopMergeStrategy = new LoopMergeStrategy(2, 0);
// 这里 需要指定写用哪个class去写，然后写到第一个sheet，名字为模板 然后文件流会自动关闭
// EasyExcel.write(fileName, DemoData.class).registerWriteHandler(loopMergeStrategy).sheet("模板").doWrite(data());
}

Example 3 with LoopMergeStrategy

use of com.alibaba.excel.write.merge.LoopMergeStrategy in project study by bage2014.

the class WriteTest method mergeWrite.

/**
 * 合并单元格
 * <p>
 * 1. 创建excel对应的实体对象 参照{@link DemoData}
 * <p>
 * 2. 创建一个merge策略 并注册
 * <p>
 * 3. 直接写即可
 */
@Test
public void mergeWrite() {
    String fileName = TestFileUtil.getPath() + "mergeWrite" + System.currentTimeMillis() + ".xlsx";
    // 每隔2行会合并 把eachColumn 设置成 3 也就是我们数据的长度，所以就第一列会合并。当然其他合并策略也可以自己写
    LoopMergeStrategy loopMergeStrategy = new LoopMergeStrategy(2, 0);
    // 这里 需要指定写用哪个class去写，然后写到第一个sheet，名字为模板 然后文件流会自动关闭
    EasyExcel.write(fileName, DemoData.class).registerWriteHandler(loopMergeStrategy).sheet("模板").doWrite(data());
}

Example 4 with LoopMergeStrategy

use of com.alibaba.excel.write.merge.LoopMergeStrategy in project easyexcel by alibaba.

the class AbstractWriteHolder method dealLoopMerge.

private void dealLoopMerge(List<WriteHandler> handlerList, Head head) {
    LoopMergeProperty loopMergeProperty = head.getLoopMergeProperty();
    if (loopMergeProperty == null) {
        return;
    }
    handlerList.add(new LoopMergeStrategy(loopMergeProperty, head.getColumnIndex()));
}

Example 5 with LoopMergeStrategy

use of com.alibaba.excel.write.merge.LoopMergeStrategy in project easyexcel by alibaba.

the class FillDataTest method complexFill.

private void complexFill(File file, File template) {
    try (ExcelWriter excelWriter = EasyExcel.write(file).withTemplate(template).build()) {
        WriteSheet writeSheet = EasyExcel.writerSheet().registerWriteHandler(new LoopMergeStrategy(2, 0)).build();
        FillConfig fillConfig = FillConfig.builder().forceNewRow(Boolean.TRUE).build();
        excelWriter.fill(data(), fillConfig, writeSheet);
        excelWriter.fill(data(), fillConfig, writeSheet);
        Map<String, Object> map = new HashMap<String, Object>();
        map.put("date", "2019年10月9日13:28:28");
        map.put("total", 1000);
        excelWriter.fill(map, writeSheet);
    }
    List<Object> list = EasyExcel.read(file).sheet().headRowNumber(3).doReadSync();
    Assert.assertEquals(list.size(), 21L);
    Map<String, String> map19 = (Map<String, String>) list.get(19);
    Assert.assertEquals("张三", map19.get(0));
}