Ajax请求,导出excel相关问题
问题形成:
Ajax结合配置的excel模板,导出excel时,无任何效果?
过程描述:
$.ajax({
type:"post",
url:basePath + '/manage/exports',
data:JSON.stringify(params),
contentType: "application/json;charset=utf-8",
success:function(data){
console.log("-----1230------",data)
}
});
excel配置:
//导出方法
public void export(Map<String, Object> param, HttpServletResponse response,HttpServletRequest request) throws FileNotFoundException {
// 文件根路径
String fileRootPath = request.getSession().getServletContext().getRealPath("/excelTemplate");
// 模板文件名称
String tempFileName = "xxxxxx.xls";
// 内容
Map<String, Object> bean = new HashMap<String, Object>();
bean.put("row", param);
String fileName = "故障停电.xls";
// 设置sheet页名称
String sheetName = "停电";
downFile(response, bean, fileRootPath, tempFileName, fileName, sheetName);
}
// 文件下载
public void downFile(final HttpServletResponse response, Map<String, Object> bean, String fileRootPath,String tempFileName, String fileName, String sheetName)
throws FileNotFoundException {
if (bean != null) {
XLSTransformer transformer = new XLSTransformer();
InputStream in = new FileInputStream(new File(fileRootPath + File.separator + fileName));
HSSFWorkbook workbook;
try {
workbook = (HSSFWorkbook) transformer.transformXLS(in, bean);
Sheet sheet = workbook.getSheetAt(0);
//