一、Excel下载
1.在本地新建Excel文件模板,并设置文件单元格格式(方便存储时读取数据)
2.选择字段,右键,设置单元格格式
3.将Id设置为数值类型,并且是正数值类型,将Name,Address,Sex,Content设置为文本类型
4.将文件存在服务器上,放在template下,也可以自定义字段,写代码时注意路径问题
5.代码
@Resource
private ResourceLoader resourceLoader;
//controller接口
@RequestMapping(value="/down",method= RequestMethod.GET)
public void down(HttpServletRequest request, HttpServletResponse response,
@RequestParam("fileName") String fileName){
if(fileName==null||"".equals(fileName)){
logger.info("============================文件不存在");
return;
}
messageTaskService.down(request,response,fileName);
}
//service代码
/**
* 下载任务详情模板
* @param
* @return
*/
public void down(HttpServletRequest request, HttpServletResponse response,String fileName){
if(fileName==null|| !fileName.endsWith(".xls")){
logger.info("=============downLoadModel's fileName is null or file type is wrong !");
return;
}
logger.info("=============start in downLoadModel , fileName = "+fileName);
InputStream inputStream = null;
ServletOutputStream servletOutputStream = null;
try {
String filename = fileName;
String path = "template/"+fileName;
org.springframework.core.io.Resource resource = resourceLoader.getResource("classpath:"+path);
response.setContentType("application/vnd.ms-excel");
response.addHeader("Cache-Control", "no-cache, no-store, must-revalidate");
response.addHeader("charset", "utf-8");
response.addHeader("Pragma"