Excel操作

package org.example.demosql;

import cn.hutool.core.io.FileUtil;

import cn.hutool.poi.excel.ExcelReader;

import cn.hutool.poi.excel.ExcelUtil;

import cn.hutool.poi.excel.ExcelWriter;

import org.junit.jupiter.api.Test;

import java.util.List;

import java.util.Map;

class DemoSqlApplicationTests {

    @Test

    void contextLoads() {

        ExcelReader reader = ExcelUtil.getReader(FileUtil.file("D:\\AllProjects\\IdeaProjects\\Exercitation\\Demo-sql\\db\\Students.xlsx"));

        List<Map<String, Object>> readAll = reader.readAll();

        List<Map<String, Object>> list = readAll.stream().peek(m -> m.put("academy", m.get("id"))).toList();

        list.forEach(System.out::println);

        reader.close();

        ExcelWriter excelWriter = new ExcelWriter("D:\\AllProjects\\IdeaProjects\\Exercitation\\Demo-sql\\db\\W.xlsx");

        excelWriter.write(list);

        excelWriter.flush();

        excelWriter.close();

    }

}