栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

EasyExcel动态导入-动态头

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

EasyExcel动态导入-动态头

需求说明:因为项目需求,请求头要做国际化,请求头随时更改,所以请求头为动态!

1.pom.xml引入
        
        
            com.alibaba
            easyexcel
        


2.监听引入EasyExcelListener
import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.event.AnalysisEventListener;

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


public class EasyExcelListener extends AnalysisEventListener> {
    //表头数据(存储所有的表头数据)
    private List> headList = new ArrayList<>();
    //数据体
    private List> dataList = new ArrayList<>();
    //这里会一行行的返回头
    @Override
    public void invokeHeadMap(Map headMap, AnalysisContext context) {
        //存储全部表头数据
        headList.add(headMap);
    }
    @Override
    public void invoke(Map data, AnalysisContext context) {
        dataList.add(data);
    }
    @Override
    public void doAfterAllAnalysed(AnalysisContext context) {
    }
    public List> getHeadList() {
        return headList;
    }
    public List> getDataList() {
        return dataList;
    }

}

3.工具类型生成EasyExcelImportUtils
import com.alibaba.excel.EasyExcelFactory;
import com.alibaba.excel.util.IoUtils;
import org.apache.commons.compress.utils.Lists;
import org.springframework.util.CollectionUtils;
import org.springframework.web.multipart.MultipartFile;

import java.io.*;
import java.util.ArrayList;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;


public class EasyExcelImportUtils {


    
    public static List> parseExcelToData(byte[] stream, Integer parseRowNumber) {
        EasyExcelListener readListener = new EasyExcelListener();
        EasyExcelFactory.read(new ByteArrayInputStream(stream)).registerReadListener(readListener).headRowNumber(parseRowNumber).sheet(0).doRead();
        List> headList = readListener.getHeadList();
        if(CollectionUtils.isEmpty(headList)){
            throw new RuntimeException("Excel表头不能为空");
        }
        List> dataList = readListener.getDataList();
        if(CollectionUtils.isEmpty(dataList)){
            throw new RuntimeException("Excel数据内容不能为空");
        }
        //获取头部,取最后一次解析的列头数据
        Map excelHeadIdxNameMap = headList.get(headList.size() -1);
        //封装数据体
        List> excelDataList = Lists.newArrayList();
        for (Map dataRow : dataList) {
            Map rowData = new LinkedHashMap<>();
            excelHeadIdxNameMap.entrySet().forEach(columnHead -> {
                rowData.put(columnHead.getValue(), dataRow.get(columnHead.getKey()));
            });
            excelDataList.add(rowData);
        }
        return excelDataList;
    }

    
    public static List> makeData(MultipartFile file){
        InputStream inputStream = null;//转换成输入流
        try {
            inputStream = file.getInputStream();
        } catch (IOException e) {
            e.printStackTrace();
        }
        byte[] stream = new byte[0];
        try {
            stream = IoUtils.toByteArray(inputStream);
        } catch (IOException e) {
            e.printStackTrace();
        }
        if(stream == null || stream.length == 0){
            return null;
        }
        List> dataList = parseExcelToData(stream, 1);//从动态获取全部列和数据体,默认从第一行开始解析数据
        try {
            if(inputStream != null){
                inputStream.close();
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
        return dataList;
    }


    
    public static void main(String[] args) throws IOException {
        //属性项
        FileInputStream inputStream = new FileInputStream(new File("C:\Users\Administrator\Desktop\easy_excel_test1.xlsx"));
        byte[] stream = IoUtils.toByteArray(inputStream);
        List> dataList = parseExcelToData(stream, 1);//动态获取全部列和数据体,默认从第一行开始解析数据
        List objects = new ArrayList<>();
        dataList.forEach(d->{
            objects.addAll(d.keySet());
        });
        System.out.println("属性项:"+objects);
        System.out.println("值:"+dataList);
        inputStream.close();
    }
}
4.控制层EasyExcelController 
@RequestMapping
@RestController
public class EasyExcelController {

    
    @PostMapping("toExportInt")
    public Result toExceptInt(MultipartFile file){
        List> list = EasyExcelImportUtils.makeData(file);
        return Result.success(list);
    }
}

积累一点点。。。。。。。。。。

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/936601.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号