package com.ycl.utils;
|
|
import com.alibaba.excel.EasyExcel;
|
import com.alibaba.excel.read.builder.ExcelReaderBuilder;
|
import com.alibaba.excel.read.builder.ExcelReaderSheetBuilder;
|
import lombok.extern.slf4j.Slf4j;
|
|
import java.io.InputStream;
|
import java.util.List;
|
|
/**
|
* excel工具
|
*
|
* @author 安瑾然
|
* @date 2022/09/11
|
*/
|
@Slf4j
|
public class ExcelUtils {
|
|
/**
|
* 将excel文件流转换成实体类
|
*
|
* @param inputStream 输入流
|
* @param clazz 泛型
|
* @return {@link List}<{@link T}>
|
*/
|
public static <T> List<T> getExcelModelData(final InputStream inputStream, Class<T> clazz) {
|
if (null == inputStream) {
|
throw new NullPointerException("the inputStream is null!");
|
}
|
ExcelReaderBuilder result = EasyExcel.read(inputStream, clazz, null);
|
ExcelReaderSheetBuilder sheet1 = result.sheet();
|
List<T> resultData = sheet1.doReadSync();
|
return resultData;
|
}
|
}
|
