//批量导出+文件下载+文件删除
@RequestMapping("/downLoad")
public String dasa(HttpServletResponse response) throws IOException {
String path = ResourceUtils.getURL("classpath:").getPath()+"/static/files";
String dataDirPath = path+"/"+new SimpleDateFormat("yyy-MM-dd").format(new Date());
File dateFile = new File(dataDirPath);
if(!dateFile.exists()){
dateFile.mkdirs();
}
String dateFile1 = dateFile+"/"+"save.xlsx";
ExcelWriterBuilder workBook = EasyExcel.write(dateFile1,Student.class);
List<Student> s = new ArrayList<>();
//这里设置需要导出的数据,可以从数据库导入
ExcelWriterSheetBuilder sheet = workBook.sheet();
sheet.doWrite(s);
File date = new File(dateFile1);
FileInputStream is = new FileInputStream(date);
response.setHeader("Content-Disposition",
"attachment; filename=
文件上传+easyExcel批量导入+ 文件删除,批量导出+文件下载
最新推荐文章于 2024-04-22 14:57:42 发布