ajax와 jxls 로 엑셀 다운로드 하기(응답헤더 설정)

Question

전자정부 프레임워크를 사용합니다.$.ajax({ type : "POST", url : "./comm/excelDownload.do", data : senddata, contentType:"application/json",//전송할 데이터 타입 dataType: 'blob',//서버로부터 수신할 데이터 타입 success: function(response) { var blob = new Blob([response]); console.log(blob); var link = document.createElement('a'); link.href = window.URL.createObjectURL(blob); link.download = 'Download_jxls_jetf.xls'; link.click(); }, error: function(xhr, status, error) { console.error(error); } });@RequestMapping (value = "/excelDownload.do", method=RequestMethod.POST) public void excelDownload(HttpServletRequest request, HttpServletResponse response, HttpSession session, @RequestBody String jsonstring) throws IOException { System.out.println("hi"); System.out.println("## controller in"); String decodedstr = URLDecoder.decode(jsonstring, "UTF-8"); //프론트에서 받은 문자열 디코딩된 버전 ObjectMapper objectMapper = new ObjectMapper(); List jetfans = objectMapper.readValue(decodedstr, new TypeReference>>() {}); System.out.println(jetfans.size()); OutputStream os = response.getOutputStream(); response.setHeader("Content-Disposition", "attachment; filename = \"Download_jxls_jetf.xls\""); response.setContentType("application/vnd.ms-excel"); try( InputStream is = getClass().getResourceAsStream("/jxlsTemplate/jxls_jetf.xls");){ Context context = new Context(); context.putVar("jetfans", jetfans); System.out.println("is = "+is); System.out.println("os = "+os); JxlsHelper.getInstance().processTemplate(is, os, context); System.out.println("server complete"); } catch (IOException e) { e.printStackTrace(); } } 컨트롤러에서 response.setcontenttype메소드로 응답헤더를 설정해줬는데 크롬 개발자도구 에서 응답헤더에 Content-Type:text/html;charset=utf-8 라고 나오는데 어떻게 해결하나요? 그리고 동시에 404에러가 떠요 ㅠ url, method 다 제대로 되어있는데

MungGaeDev · Answer

// js $.ajax({ type: "POST", url: "./comm/excelDownload.do", data: senddata, contentType: "application/json", //전송할 데이터 타입 dataType: "blob", //서버로부터 수신할 데이터 타입 success: function (response) { var blob = new Blob([response]); console.log(blob); var link = document.createElement("a"); link.href = window.URL.createObjectURL(blob); link.download = "Download_jxls_jetf.xls"; link.click(); }, error: function (xhr, status, error) { console.error(error); }, }); //JAVA @RequestMapping(value = "/excelDownload.do", method = RequestMethod.POST) public void excelDownload(HttpServletRequest request, HttpServletResponse response, HttpSession session, @RequestBody String jsonstring) throws IOException { System.out.println("hi"); System.out.println("## controller in"); String decodedstr = URLDecoder.decode(jsonstring, "UTF-8"); //프론트에서 받은 문자열 디코딩된 버전 ObjectMapper objectMapper = new ObjectMapper(); List < jetfanClass > jetfans = objectMapper.readValue(decodedstr, new TypeReference < List < Map < String, Object >>> () {}); System.out.println(jetfans.size()); OutputStream os = response.getOutputStream(); response.setHeader("Content-Disposition", "attachment; filename = \"Download_jxls_jetf.xls\""); response.setContentType("application/vnd.ms-excel"); try (InputStream is = getClass().getResourceAsStream("/jxlsTemplate/jxls_jetf.xls");) { Context context = new Context(); context.putVar("jetfans", jetfans); System.out.println("is = " + is); System.out.println("os = " + os); JxlsHelper.getInstance().processTemplate(is, os, context); System.out.println("server complete"); } catch (IOException e) { e.printStackTrace(); } }

포기해.. · Answer

url : "./comm/excelDownload.do",@RequestMapping (value = "/excelDownload.do", url이 다른데요

ajax와 jxls 로 엑셀 다운로드 하기(응답헤더 설정)

2개의 답변

Q&A 목록