ssh下载excel文件
来源:互联网 发布:九州世界观知乎 编辑:程序博客网 时间:2024/05/16 06:27
public void downloadExcel(){
HttpServletRequest request = ServletActionContext.getRequest();
HttpServletResponse response=ServletActionContext.getResponse();
BufferedInputStream in = null;
BufferedOutputStream out = null;
try {
response.setContentType("text/html;charset=UTF-8");
request.setCharacterEncoding("UTF-8");
URL url = CommonTouristAction.class.getResource("");
String path = url.getPath().toString().replace("WEB-INF/classes/.*", "");
String path1[] = path.split("WEB-INF/classes/");
path = path1[0] + "model/xls/commonTouristModel.xls";
String fileName =URLEncoder.encode("常用旅客信息导入模板.xls", "UTF-8") ;
File f = new File(path);
response.setContentType("application/x-excel");
response.setCharacterEncoding("UTF-8");
response.setHeader("Content-Disposition", "attachment; filename="+fileName);
response.setHeader("Content-Length",String.valueOf(f.length()));
in = new BufferedInputStream(new FileInputStream(f));
out = new BufferedOutputStream(response.getOutputStream());
byte[] data = new byte[1024];
int len = 0;
while (-1 != (len=in.read(data, 0, data.length))) {
out.write(data, 0, len);
}
} catch (Exception e) {
logger.error("下载模版异常:",e);
} finally {
if (in != null) {
try {
in.close();
} catch (IOException e) {
logger.error("下载模版异常:",e);
}
}
if (out != null) {
try {
out.close();
} catch (IOException e) {
logger.error("下载模版异常:",e);
}
}
}
}
HttpServletRequest request = ServletActionContext.getRequest();
HttpServletResponse response=ServletActionContext.getResponse();
BufferedInputStream in = null;
BufferedOutputStream out = null;
try {
response.setContentType("text/html;charset=UTF-8");
request.setCharacterEncoding("UTF-8");
URL url = CommonTouristAction.class.getResource("");
String path = url.getPath().toString().replace("WEB-INF/classes/.*", "");
String path1[] = path.split("WEB-INF/classes/");
path = path1[0] + "model/xls/commonTouristModel.xls";
String fileName =URLEncoder.encode("常用旅客信息导入模板.xls", "UTF-8") ;
File f = new File(path);
response.setContentType("application/x-excel");
response.setCharacterEncoding("UTF-8");
response.setHeader("Content-Disposition", "attachment; filename="+fileName);
response.setHeader("Content-Length",String.valueOf(f.length()));
in = new BufferedInputStream(new FileInputStream(f));
out = new BufferedOutputStream(response.getOutputStream());
byte[] data = new byte[1024];
int len = 0;
while (-1 != (len=in.read(data, 0, data.length))) {
out.write(data, 0, len);
}
} catch (Exception e) {
logger.error("下载模版异常:",e);
} finally {
if (in != null) {
try {
in.close();
} catch (IOException e) {
logger.error("下载模版异常:",e);
}
}
if (out != null) {
try {
out.close();
} catch (IOException e) {
logger.error("下载模版异常:",e);
}
}
}
}
0 0
- ssh下载excel文件
- 在线实时生成Excel文件流供下载 (SSH)
- 下载文件Excel文件
- linux ssh下载文件
- ssh 传送下载文件
- ssh文件下载
- Excel文件下载
- jsp下载文件 excel
- excel文件下载
- SpringMvc下载excel文件
- 下载excel、xml文件
- Java Excel文件下载
- Spring下载excel文件
- SpringMvc下载excel文件
- SpringMvc下载excel文件
- php下载excel文件
- excel模板文件下载
- Java下载Excel文件
- service(1)
- POJ 2750:鸡兔同笼
- input js验证只能是数字,有小数点
- C#学习笔记:c# 从EXCEL 读取信息并保存到dataset中
- 收藏
- ssh下载excel文件
- Android之NDK开发
- POJ 2764:数根
- QT transplant environment
- 字符串的显示宽度
- Hadoop面试45个题目及答案
- POJ 2796:数字求和
- 文件过滤器 FileFilter
- POJ 2807:两倍