SpringBoot集成EasyPoi

最新推荐文章于 2024-09-27 11:40:51 发布

八卦程序

最新推荐文章于 2024-09-27 11:40:51 发布

阅读量3.5k

点赞数

分类专栏： Spring 文章标签： SpringBoot EasyPoi

本文链接：https://blog.csdn.net/wu_boy/article/details/85014359

版权

Spring 专栏收录该内容

17 篇文章 1 订阅

订阅专栏

参考EasyPoi官网，需要引入

        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-spring-boot-starter</artifactId>
        </dependency>

定义实体User

package com.wu.parker.easypoi.po;

import cn.afterturn.easypoi.excel.annotation.Excel;

import java.util.Date;

/**
 * @author: wusq
 * @date: 2018/12/15
 */

public class User {

    @Excel(name = "姓名", orderNum = "0")
    private String name;

    @Excel(name = "性别", replace = {"男_1", "女_0"}, orderNum = "1")
    private String sex;

    @Excel(name = "出生日期", exportFormat = "yyyy-MM-dd", orderNum = "2")
    private Date birthday;
    
    // 请自行添加get/set方法
}

UserController

package com.wu.parker.easypoi.controller;

import cn.afterturn.easypoi.excel.ExcelImportUtil;
import cn.afterturn.easypoi.excel.entity.ImportParams;
import com.wu.parker.common.web.BaseResult;
import com.wu.parker.easypoi.po.User;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.http.HttpStatus;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

import java.util.List;

/**
 * @author: wusq
 * @date: 2018/12/15
 */
@Api(description = "用户服务")
@RestController
@RequestMapping("/users/")
public class UserController {

    private static final Logger log = LoggerFactory.getLogger(UserController.class);

    @ApiOperation("导入excel")
    @PostMapping("import-excel")
    public BaseResult importExcel(@RequestParam("file") MultipartFile file){
        BaseResult result = new BaseResult();

        try {
            ImportParams params = new ImportParams();
            params.setTitleRows(0);
            params.setHeadRows(1);
            List<User> userList = ExcelImportUtil.importExcel(file.getInputStream(), User.class, params);
            userList.forEach(o -> System.out.println(o));
        } catch (Exception e) {
            result.setCode(HttpStatus.INTERNAL_SERVER_ERROR.value());
            result.setMessage(e.getMessage());
            log.error("导入excel{}", e.getMessage());
            e.printStackTrace();
        }

        return result;
    }
}