java将excel文件保存至指定路径或者浏览器默认下载路径

啊猿

已于 2022-06-17 16:46:31 修改

阅读量4.4k

点赞数 1

文章标签： javascript spring json 前端 java

于 2022-05-12 17:25:55 首次发布

本文链接：https://blog.csdn.net/weixin_49419695/article/details/124735835

版权

指定磁盘路径：

HSSFWookbook wb = new HSSFWookbook();

//表中写数据 省略

String fileName= "表名.xls";
LocalDateTime date = LocalDateTime.now();

String path = String.format("D:\\a\\%d\\%d\\",date.getYear(),date.getMonth().getValue());
File pathFile = new File(path);
if(!pathFile.exists()){
	if(!pathFile.mkdirs()){
		throw new RuntimeException("创建文件路径错误")
	}
}
try{
		FileOutputStream fileOutputStream = new FileOutputStream(path + fileName);
		wb.write(fileOutputStream);
		fileOutputStream.flush();
		fileOutputStream.close();
	}catch(Exception e){
		e.printStackTrace();
}

浏览器端(可参考springmvc文件下载)
传送门：https://blog.csdn.net/weixin_49419695/article/details/123697650?spm=1001.2014.3001.5501

@RequestMapping("/sadasd")
public void a(HttpServletRequest req,HttpServletResponse res){
	//数据添加到表格省略
	String filename = "xxxx.xls";
	res.setContentType("application/vnd.ms-excel");
	res.setHeader("Contest-Disposition","filename=" + URLEncoder.encode(fileName,"UTF-8"));
	OutputStream ops = res.getOutputStream();
	wb.write(ops);
	ops.flush();
	ops.close();
}