HttpServletResponse response = getContext().getResponse(); ServletOutputStream sos = response.getOutputStream(); WritableWorkbook workbook = Workbook.createWorkbook(sos); WritableSheet sheet = workbook.createSheet("Report", 0); sheet.addCell(new Label(1, 1, "asdfasdfasdf")); response.setContentType("application/vnd.ms-excel"); response.setHeader("Expires", "0"); response.setHeader("Cache-Control", "must-revalidate, post-check=0, pre-check=0"); response.setHeader("Pragma", "public"); response.setHeader("Content-Disposition", "inline; filename=report-.xls"); workbook.write(); workbook.close(); sos.close();
Monday, July 15, 2013
Output XLS file to servlet output stream using JExcelAPI
Here's a quick way (although not the best one) to stream an Excel file generated by JExcelAPI (http://jexcelapi.sourceforge.net/). I'm using the servlet output stream in this case.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment