参考如下代码:
后端:
- @RequestMapping(value = "/exportExcel", method = RequestMethod.POST)
- @ResponseBody
- public ResponseEntity exportExcel() {
- ByteArrayOutputStream out = new ByteArrayOutputStream();
- Workbook myworkbook = new Workbook();
- IWorksheet worksheet = myworkbook.getActiveSheet();
- worksheet.getRange("A1").setValue("测试");
- myworkbook.save(out);
- byte[] contents = out.toByteArray();
- HttpHeaders headers = new HttpHeaders();
- ResponseEntity<byte[]> response = new ResponseEntity<>(contents, headers, HttpStatus.OK);
- return response;
-
- }
复制代码
前端:
- document.getElementById("export").onclick = function(){
- var xhr = new XMLHttpRequest();
- xhr.open('POST', "exportExcel", true);
- xhr.responseType = 'blob';
- xhr.onload = function(e) {
- if (this.status == 200) {
- var blob = this.response;
- saveAs(blob,"export.xlsx");
- }
- }
- xhr.send();
- }
复制代码 |