java实现excel下载

导入依赖

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

工具类

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.write.metadata.WriteSheet;
import com.bidr.pojo.Car;

import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.List;

public class ExcelUtil {
    public static void writeExcel(HttpServletResponse response, List<Car> list) throws IOException {
        ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream()).build();
        //第一个表
        WriteSheet sheet = EasyExcel.writerSheet(0, "sheet").head(Car.class).build();
        //写
        excelWriter.write(list,sheet);
        excelWriter.finish();

    }
}

Controller层

import com.bidr.pojo.Car;
import com.bidr.service.CarService;
import com.bidr.util.H_ExcelUtil;
import com.ruoyi.common.utils.poi.ExcelUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.ResponseBody;

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

@Controller
public class ExcelController {

    @Autowired
    CarService carService;
    @GetMapping("/test")
    @ResponseBody
    public void test(HttpServletResponse response) throws IOException {
        List<Car> list = new ArrayList<Car>();
        list = carService.findCar();	//查询车列表（根据需求改）
        response.setContentType("application/vnd.ms-excel");
        response.setHeader("Content-Disposition","attachment;filename" + "test.xls");
        ExcelUtil.writeExcel(response,list);
    }
}