导出有两种

浏览器*载下**

*载下**到本地磁盘

废话不多说上代码

依赖

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>easyexcel</artifactId>
    <version>3.0.5</version>
</dependency>

浏览器*载下**代码

import com.alibaba.excel.EasyExcel;
import com.alibaba.fastjson.JSON;
import com.google.common.collect.Maps;
import org.apache.commons.compress.utils.Lists;
import org.apache.commons.lang3.StringUtils;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.net.URLEncoder;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

@RestController
@RequestMapping("excel")
public class ExcelController {

    @RequestMapping("import")
    public void importExcel(HttpServletResponse response) throws IOException {
        //表头
        List<List<String>> listHead =Lists.newArrayList();
        //具体数据
        List<List<String>> dataList = Lists.newArrayList();
        //可以防止中文乱码 
        String fileName = URLEncoder.encode("表中文名称", "UTF-8").replaceAll("\\+", "%20");
        response.setHeader("Content-disposition", StringUtils.join("attachment;filename=",fileName,".xlsx"));
        EasyExcel.write(response.getOutputStream()).head(listHead).sheet("工作表名称").doWrite(dataList);
    }
}

*载下**到本地磁盘代码

@RequestMapping("import/local")
public String importExcelLocal() {
    String fileName = StringUtils.join("磁盘:\\ 表名称",".xlsx");
    //表头
    List<List<String>> listHead = Lists.newArrayList();
    //具体数据
    List<List<String>> dataList = Lists.newArrayList();
    EasyExcel.write(fileName).head(listHead).sheet("工作表名称").doWrite(dataList);
    return StringUtils.join("已成功*载下**  请查看地址 : ", fileName);
}