Problem with exporting csv file using template

[trongcuong1710]

public ActionForward createReport(ActionMapping mapping
                        , ActionForm form
                        , HttpServletRequest request
                        , HttpServletResponse response) {
                ((MenuForm)request.getSession().getAttribute("MenuForm")).setAction(Constants.ACTION_REPORT);
                ReportForm reportForm = (ReportForm)form;
                String year = reportForm.getYear();
                String month = reportForm.getMonth();
                try{
                        ServletContext context = this.getServlet().getServletContext();
                        String path = context.getRealPath("/WEB-INF/classes/template.csv");
                        FileInputStream fileInputStream = new FileInputStream(path);
                        HSSFWorkbook workbook = new HSSFWorkbook(fileInputStream);                      
                        reportBusiness.report(year, month, workbook);
                        response.setContentType("Text/csv");
                        response.setCharacterEncoding("UTF-8");
                        response.setHeader("Content-Disposition", "attachment;filename=report.csv");
                        ServletOutputStream outputStream = response.getOutputStream();
                        workbook.write(outputStream);
                        outputStream.close();
                }
                catch (Exception exception){
                        System.out.println(exception.getMessage());
                }
               
                return null;    
        }

the code above i write to export report.csv base on template.csv format, but when i run the web, it always export report.xls, although i changed the file name already, so can anyone take a look of it and help me toa resolve this problem

[travishein]

I think it is because the HSSFWorkbook wants to write out an .xls file.

You would need to instead have the .xls contents converted to .csv and have that written out, instead of the workbook directly writing to the output stream. see also: How can I convert HSSFWorkbook into a CSV file..? - Stack Overflow