import org.springframework.http.ResponseEntity;
import org.springframework.http.HttpHeaders;
import org.springframework.http.HttpStatus;
import org.springframework.http.MediaType;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.commons.io.FileUtils;
@RequestMapping(value = "/downLoadmoban",method = RequestMethod.GET)
public ResponseEntity downLoadmoban(HttpServletRequest request, HttpServletResponse response) throws IOException{
String rootpath = request.getSession().getServletContext().getRealPath("/muban");//获取项目中的模板文件夹
File file=new File(rootpath + File.separator + "ceshi.xls");
HttpHeaders headers = new HttpHeaders();
String fileName=new String("测试统计表导入模板.xls".getBytes("gb2312"),"iso-8859-1");//为了解决中文名称乱码问题
headers.setContentType(MediaType.APPLICATION_OCTET_STREAM);
headers.set(HttpHeaders.CONTENT_DISPOSITION, "attachment; filename=\"" + fileName + "\"");
return new ResponseEntity(FileUtils.readFileToByteArray(file),
headers, HttpStatus.OK);
}
java下载excel模板文件例子
关注
打赏