基于springMVC+POI 实现最简单的excel-xlsx导出下载功能
@Controller
@RequestMapping("/meteo/test")
public class TestController {
@Autowired
private WaterPointService waterPointService;
@RequestMapping(value = "/downLoadExcel", method = RequestMethod.GET)
public String downLoadExcel(HttpServletRequest request, HttpServletResponse response) throws IOException{
List<MeteoMonitor> meteoMonitors = waterPointService.getMeteoMonitorList();
if (meteoMonitors != null && meteoMonitors.size() > 0) {
String fileName = "test.xlsx";
response.setHeader("Content-disposition", "attachment;filename="
+ new String(fileName.getBytes(