gditDataAnaliysis/serve/src/test/java/space/anyi/BI/util/ExcelUtilsTest.java

package space.anyi.BI.util;

import cn.hutool.poi.excel.ExcelReader;
import cn.hutool.poi.excel.ExcelUtil;
import org.junit.jupiter.api.Test;

import java.util.List;
import java.util.Map;

import static org.junit.jupiter.api.Assertions.*;

/**
 * @ProjectName: serve
 * @FileName: ExcelUtilsTest
 * @Author: 杨逸
 * @Data:2024/12/3 22:16
 * @Description:
 */
class ExcelUtilsTest {

    @Test
    void readExcel() {
        String filePath = "E:\\2024\\BI\\serve\\test.xlsx";
        //List<Map<Integer, String>> maps = ExcelUtils.readExcel(filePath);
        ExcelReader reader = ExcelUtil.getReader(filePath);
        List<Map> list = reader.readAll(Map.class);
        for (Map map : list) {
            System.out.println("map = " + map);
        }
    }

    @Test
    void testReadExcel() {
    }
}