前端:
html:
<div style="margin-top: 20px">
<el-button @click="downloadDemo" size="small">下载模板</el-button>
</div>
js:
downloadDemo () {
let url = Config.context + '/userManager/downloadExcel'
this.common.exportData(url, this.queryForm, '数据模板_' + this.common.getTime())
}
exportData (url, data, fileName) {
axios({
method: 'POST',
url: url,
data: data,
responseType: 'blob'
}).then(response => {
if (!response) {
return
}
const blob = new Blob([response.data])
if (window.navigator && window.navigator.msSaveOrOpenBlob) {
navigator.msSaveBlob(blob, fileName)
} else {
let u = window.URL.createObjectURL(response.data)
let aLink = document.createElement('a')
aLink.style.display = 'none'
aLink.href = u
aLink.setAttribute('download', fileName + '.xlsx')
document.body.appendChild(aLink)
aLink.click()
document.body.removeChild(aLink)
window.URL.revokeObjectURL(u)
}
}).catch(error => {
throw error
})
}
后端:
controller层:
@RequestMapping("/downloadExcel")
public ResponseEntity<byte[]> download2() throws IOException {
File file = excelModelService.buildXlsById();
return FileUtils.buildResponseEntity(file);
}
service层:
import org.springframework.stereotype.Service;
import org.springframework.util.ResourceUtils;
import java.io.File;
import java.io.FileNotFoundException;
@Service
public class ExcelModelService {
public File buildXlsById(){
//do something to find this file
File file=null;
try {
file = ResourceUtils.getFile("classpath:templates/model.xlsx");
} catch (FileNotFoundException e) {
e.printStackTrace();
}
return file;
}
}
这里写的是静态文件的存放路径,注意不能中文名不然识别不了
文件下载工具类:
public static ResponseEntity<byte[]> buildResponseEntity(File file) throws IOException {
byte[] body = null;
//获取文件
InputStream is = new FileInputStream(file);
body = new byte[is.available()];
is.read(body);
HttpHeaders headers = new HttpHeaders();
//设置文件类型
headers.add("Content-Disposition", "attchement;filename=" + file.getName());
//设置Http状态码
HttpStatus statusCode = HttpStatus.OK;
//返回数据
ResponseEntity<byte[]> entity = new ResponseEntity<byte[]>(body, headers, statusCode);
return entity;
}
后续补充:
以上方式实现在开发环境没有任何问题,但是在生产环境会出现无法下载后台报错的情况,原因在于用流的方式读取文件,打成jar包之后,下载的文件会被损坏 ,后来网上说配置pom里面文件路径等等试了没用,直接用了POI的导出
修改后controller:
@RequestMapping(value="/downloadExcel")
public ResponseEntity<Resource> excel2007Export(HttpServletResponse response, HttpServletRequest request) {
try {
ClassPathResource cpr = new ClassPathResource("/templates/"+"model.xlsx");
InputStream is = cpr.getInputStream();
Workbook workbook = new XSSFWorkbook(is);
String fileName = "model.xlsx";
downLoadExcel(fileName, response, workbook);
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return new ResponseEntity<Resource>(HttpStatus.OK);
}
文件工具类downLoadExcel:
public static void downLoadExcel(String fileName, HttpServletResponse response, Workbook workbook) {
try {
response.setCharacterEncoding("UTF-8");
response.setHeader("content-Type", "application/vnd.ms-excel");
response.setHeader("Content-Disposition",
"attachment;filename=\"" + URLEncoder.encode(fileName, "UTF-8") + "\"");
workbook.write(response.getOutputStream());
} catch (IOException e) {
e.printStackTrace();
}
}