renren框架下
一、vue 客户端
- 安装
cnpm install js-file-download --save
- 2 引用
var fileDownload = require('js-file-download')
- 3请求controller 流
exportDz () {
let url = this.$http.adornUrl('/drg/hisbasysscz/exportDz')
let data = {
'page': this.pageIndex,
'limit': this.pageSize,
'key': this.dataForm.key
}
this.$http.post(url, data, {responseType: 'arraybuffer'}).then(res => {
fileDownload(res.data, 'test2.xlsx')
}).catch(error => {
console.log(error)
})
},
二、Java 端 easyExcel
/**
* 文件导出
* 测试地址 http://localhost:8080/renren-fast/drg/hisbasysscz/exportDz
* @param request
* @param response
*/
@RequestMapping(value = {"exportDz", ""})
@ResponseBody
public void exportDz( HttpServletRequest request, HttpServletResponse response){
//1. 数据
List<Map<String, Object>> list = new ArrayList<>();
Map<String, Object> map2 = new HashMap<>();
map2.put("name", "洪财测试");
list.add(map2);
String templatePath = "D:\\dev\\workspace_idea\\renren-fast\\src\\main\\resources\\excel\\test_template.xlsx";
DownloadExcelUtils.download(response, list, "filename", templatePath);
}