js export method:
$scope.showYes = function () {
var needFields = getTheNeedFields();
$http.post("/aa.do?fields="+needFields, {responseType: 'arraybuffer'}).then(function (response) {
var data = new Blob([response.data], {type: response.headers('Content-Type')});
var filename = response.headers('Content-Disposition').split(';')[1].trim().substr('filename='.length);
FileSaver.saveAs(data, filename);
});
};
Server-side processing method:
@RequestMapping("/aa")
public void testExportDynamic(HttpServletResponse response) throws IOException {
String fileName = System.currentTimeMillis()+"";
response.setCharacterEncoding("UTF-8");
response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; charset=UTF-8");
response.setHeader("Content-disposition", "attachment;filename=" + URLEncoder.encode(fileName, "utf-8")+ ".xlsx");
OutputStream os = response.getOutputStream();
Map map = new HashMap();
String fields = request.getParameter("fields");
map.put("fields", fields);
//Map对象,带null的对象
List<HashMap> result = userDao.loadDatasBySelectionFields(map);
XSSFWorkbook workbook = MehtodApis.exportExcelFile(result, fields);
// OutputStream os = new FileOutputStream("D:/export2007_" + System.currentTimeMillis() + ".xlsx");
//
workbook.write(os);
os.close();
}
But the downloaded file is like this:
Console:
If I use this kind of output excel to find the path, the file will be fine.
Map map = new HashMap();
String fields = request.getParameter("fields");
map.put("fields", fields);
//Map对象,带null的对象
List<HashMap> result = userDao.loadDatasBySelectionFields(map);
XSSFWorkbook workbook = MehtodApis.exportExcelFile(result, fields);
OutputStream os = new FileOutputStream("D:/export2007_" + System.currentTimeMillis() + ".xlsx");
workbook.write(os);
os.close();
What about the Shenma problem? How to deal with it?
Take a breakpoint trace and check the memory snapshot to see if there is any problem with your data and whether it is consistent with the version of excel you opened