简单excel数据导入

最新推荐文章于 2024-10-15 11:12:14 发布

HUOvO

最新推荐文章于 2024-10-15 11:12:14 发布

阅读量163

点赞数 2

文章标签： excel java

本文链接：https://blog.csdn.net/HUOvO/article/details/139226340

版权

实体类

public class BusiLandProjectExcel {
    /**
     * id
     */
    @ApiModelProperty(value = "id")
    @ExcelProperty(index = 0, value = "序号")
    private Integer id;

    /**
     * 农田项目名称
     */
    @ApiModelProperty(value = "农田项目名称")
    @ExcelProperty(index = 1, value = "农田项目名称")
    private String landProjectName;


    /**
     * 建设单位
     */
    @ApiModelProperty(value = "建设单位")
    @ExcelProperty(index = 4, value = "建设单位")
    private String buildUnit;

    /**
     * 建设地点
     */
    @ApiModelProperty(value = "建设地点")
    @ExcelProperty(index = 5, value = "建设地点")
    private String buildAddress;

    /**
     * 建设主要内容
     */
    @ApiModelProperty(value = "建设主要内容")
    @ExcelProperty(index = 6, value = "建设主要内容")
    private String buildMainContent;

    /**
     * 建设开始年份
     */
    @ApiModelProperty(value = "建设开始年份")
    @ExcelProperty(index = 7, value = "建设开始年份")
    private String buildStartYear;

    /**
     * 建设结束年份
     */
    @ApiModelProperty(value = "建设结束年份")
    @ExcelProperty(index = 8, value = "建设结束年份")
    private String buildEndYear;

    /**
     * 总建设面积_亩
     */
    @ApiModelProperty(value = "总建设面积_亩")
    @ExcelProperty(index = 9, value = "总建设面积_亩")
    private Double totalInvestment;

    /**
     * 是否完成验收
     */
    @ApiModelProperty(value = "是否完成验收")
    @ExcelProperty(index = 10, value = "是否完成验收")
    private String iCompleteAcceptance;

    /**
     * 实际完成建设面积_亩
     */
    @ApiModelProperty(value = "实际完成建设面积_亩")
    @ExcelProperty(index = 11, value = "实际完成建设面积_亩")
    private Double actualFinishInvestment;

    /**
     * 竣工验收时间
     */
    @ApiModelProperty(value = "竣工验收时间")
    @ExcelProperty(index = 12, value = "竣工验收时间")
    private Date completionTime;

    /**
     * 行政区划名称
     */
    @ApiModelProperty(value = "行政区划名称")
    @ExcelProperty(index = 13, value = "行政区划名称")
    private String administrativeDivisionName;

    /**
     * 行政区划代码
     */
    @ApiModelProperty(value = "行政区划代码")
    @ExcelProperty(index = 14, value = "行政区划代码")
    private String administrativeDivisionCode;


}

监听类

package com.seerbigdata.village.business.listener;

import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.event.AnalysisEventListener;
import com.seerbigdata.village.business.domain.excel.BusiLandProjectExcel;
import lombok.extern.slf4j.Slf4j;

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

/**
 * @Author: HuYongHui
 * @Date: 2024/5/22
 * Content:
 */
@Slf4j
public class BusiLandProjectListener extends AnalysisEventListener<BusiLandProjectExcel> {
    // 存储每个sheet的所有数据
    ArrayList<BusiLandProjectExcel> modelList = new ArrayList<>();

    @Override
    public void invoke(BusiLandProjectExcel busiLandProjectExcel, AnalysisContext analysisContext) {
        modelList.add(busiLandProjectExcel);
    }

    @Override
    public void doAfterAllAnalysed(AnalysisContext analysisContext) {
        log.info("所有数据解析完成！");
    }

    public List<BusiLandProjectExcel> getData() {
        return modelList;
    }

}

逻辑代码

@Override
    public Boolean upload(MultipartFile file) throws IOException{
        if (file == null) {
            throw new GlobalException("请选择上传文件");
        }
        BusiLandProjectListener listener = new BusiLandProjectListener();
        try {
            EasyExcel.read(file.getInputStream(), BusiLandProjectExcel.class, listener).sheet().doRead();
            // 获取数据列表
            List<BusiLandProjectExcel> data = listener.getData();
            if (CollectionUtil.isEmpty(data)) {
                throw new GlobalException("表格无数据，请重试！");
            }
            List<BusiLandProject> busiLandProjects = data.stream().map(busiLandProjectExcel -> {
                BusiLandProject busiLandProject = new BusiLandProject();
                BeanUtil.copyProperties(busiLandProjectExcel, busiLandProject);
                if ("是".equals(busiLandProjectExcel.getICompleteAcceptance())){
                    busiLandProject.setIsCompleteAcceptance(true);
                }else{
                    busiLandProject.setIsCompleteAcceptance(false);
                }
                busiLandProject.setFarmlandAttribute(HIGH_STANDARD_FARMLAND.getVal());
                return busiLandProject;
            }).collect(Collectors.toList());
            this.saveBatch(busiLandProjects);
        } catch (IOException e) {
            log.error("导入表格数据失败:{}".concat(e.getMessage()));
            throw new GlobalException("导入表格数据失败");
        }
        return Boolean.TRUE;
    }