2024年4月13日发(作者:)
java下载excel文件
原代码剪切图片:
修改后剪切图片:
源码:
public void downloadTaskModel()throws Exception{
HttpServletResponse
text().getResponse();
response =
HttpServletRequest request = text().getRequest();
String path = lPath("/");
path = new String(es("iso-8859-1"),"GBK");
String matches = "[A-Za-z]:[^:?"><*]*";
if(!s(matches)){
throw new Exception("文件路径存在非法字符!");
}
path = eAll("", "/");
File file = new File(path+"/templateFile/");
if(!()||!()||ctory()){
throw new Exception("下载的文件路径或文件不存在!");
}
//由于限制了导入模板的类型,所以在导出模板时必须限制。
if(!e().matches(".*.(?i)(xls)$")){
throw new Exception("当前模板类型有误,只能导出“.xls”格式的excel模板!");
}
tentType("application/x-msdownload");
tentLength((int)());
String taskNme = eStr(new Date(), "yyyyMMddHHmmss");
der("Content-Disposition",
"attachment;filename="+("模板"+taskNme+".xls","UTF-8"));
FileInputStream fis = new FileInputStream(file);
BufferedInputStream buff = new BufferedInputStream(fis);
byte b[] = new byte[1024];
long k = 0 ;
OutputStream myout = putStream();
while(k<()){
int j = (b,0,1024);
k += j ;
(b,0,j);
}
();
();
}


发布评论