2. excel java实现对角线数据复制

0. excel 样式

1. 需要工具:hutool

2. maven依赖:

<dependency>

<groupId>cn.hutool</groupId>

<artifactId>hutool-all</artifactId>

<version>5.2.5</version>

</dependency>

<dependency>

<groupId>org.apache.poi</groupId>

<artifactId>poi-ooxml</artifactId>

<version>3.17</version>

</dependency>

3. java代码:

public static void main(String[] args) {

ExcelReader reader = ExcelUtil.getReader("E:/test.xlsx");

List> readAll = reader.readAll();

Integer m =2;

Map indexHeader =new HashMap<>();

indexHeader.put(0,"100");

indexHeader.put(1,"201");

indexHeader.put(2,"202");

indexHeader.put(3,"203");

indexHeader.put(4,"204");

for (int i =0; i < readAll.size(); i++) {

LinkedHashMap linkedHashMap = (LinkedHashMap) readAll.get(i);

for (int j = m; j < linkedHashMap.size(); j++) {

LinkedHashMap clomn = (LinkedHashMap) readAll.get(j -1);

String clomnHeader = indexHeader.get(i);

String header = indexHeader.get(j -1);

linkedHashMap.put(header, clomn.get(clomnHeader));

}

m = m +1;

}

//通过工具类创建writer

    ExcelWriter writer = ExcelUtil.getWriter("E:/testNew.xlsx");

//一次性写出内容,强制输出标题

    writer.write(readAll,true);

//关闭writer,释放内存

    writer.close();

}

©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容