importcom.bidr.pojo.Car;importcom.bidr.service.CarService;importcom.bidr.util.H_ExcelUtil;importcom.ruoyi.common.utils.poi.ExcelUtil;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.stereotype.Controller;importorg.springframework.web.bind.annotation.GetMapping;importorg.springframework.web.bind.annotation.ResponseBody;importjavax.servlet.http.HttpServletResponse;importjava.io.IOException;importjava.util.ArrayList;importjava.util.List;@ControllerpublicclassExcelController{@AutowiredCarService carService;@GetMapping("/test")@ResponseBodypublicvoidtest(HttpServletResponse response)throwsIOException{List<Car> list =newArrayList<Car>();
list = carService.findCar();//查询车列表(根据需求改)
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition","attachment;filename"+"test.xls");ExcelUtil.writeExcel(response,list);}}