spmkkmps Posted June 18, 2009 Share Posted June 18, 2009 hiWhen i try to export it to excel using JRXlsExporter it gives the following error,java.lang.NoSuchMethodError: org.apache.poi.hssf.usermodel.HSSFSheet.setColumnHidden(SZ)V net.sf.jasperreports.engine.export.JRXlsExporter.removeColumn(JRXlsExporter.java:214) net.sf.jasperreports.engine.export.JRXlsAbstractExporter.removeEmptyColumns(JRXlsAbstractExporter.java:636) net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:439) net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:197) com.jeevan.ReportExcelFormat.doGet(ReportExcelFormat.java:89) javax.servlet.http.HttpServlet.service(HttpServlet.java:617)can anybody tell me if anything needs to be changed or do i need to add any jar files.and i have added poi-2.5.1.jar and poi-3.0.1-FINAL-20070705.jar in the appln but even it doesnot work.please do reply asap. its very urgent. Thanks in advance.madhan Code:public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { ServletOutputStream outputStream = response.getOutputStream(); InputStream reportStream = getServletConfig().getServletContext().getResourceAsStream("ReportPDFFormat.jasper"); CsvDataSource csvDataSource = new CsvDataSource(new InputStreamReader(getServletConfig().getServletContext().getResourceAsStream("ReportPDFFormat.csv"))); try{ //ByteArrayOutputStream outputStream = new ByteArrayOutputStream(); JasperPrint jasperPrint = null; File f = new File("C:/reportexcel.xls"); jasperPrint = JasperFillManager.fillReport(reportStream, new HashMap(), csvDataSource); OutputStream out = new FileOutputStream(f); JRXlsExporter exporterXLS = new JRXlsExporter(); exporterXLS.setParameter(JRXlsExporterParameter.JASPER_PRINT, jasperPrint); exporterXLS.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, outputStream); exporterXLS.setParameter(JRXlsExporterParameter.OFFSET_X,0); exporterXLS.setParameter(JRXlsExporterParameter.OFFSET_Y,0); exporterXLS.setParameter(JRXlsExporterParameter.START_PAGE_INDEX,0); exporterXLS.setParameter(JRXlsExporterParameter.IS_IGNORE_GRAPHICS,true); exporterXLS.setParameter(JRXlsExporterParameter.MAXIMUM_ROWS_PER_SHEET,65000); exporterXLS.setParameter(JRXlsExporterParameter.IS_FONT_SIZE_FIX_ENABLED,false); exporterXLS.setParameter(JRXlsExporterParameter.IS_IGNORE_CELL_BORDER,false); exporterXLS.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET,false); exporterXLS.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE,false); exporterXLS.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, false); exporterXLS.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,true); exporterXLS.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS,true); exporterXLS.exportReport(); System.out.println("fsdfsd"); response.setContentType("application/vnd.ms-excel"); outputStream.flush(); outputStream.close(); System.out.println("fsdfsd1234"); //out.write(outputStream.toByteArray()); // byte[] buf2 = new byte[(int)f.length()]; //httpSession.setAttribute("fileupload_bytes",buf2); //httpSession.setAttribute("fileupload_type", "application/vnd.ms-excel"); //httpSession.setAttribute("fileupload_name", realpath+"/SpecImages/download/"+report.substring(lastslashindex+1, lastdot)+"_"+empId+".xls"); } catch (JRException e){ e.printStackTrace(); } } Link to comment Share on other sites More sharing options...
spmkkmps Posted June 19, 2009 Author Share Posted June 19, 2009 hi,i have kept the two jar files in the build path. after removing poi-2.5.1.jar it works fine for me. thanks. Link to comment Share on other sites More sharing options...
satishp_1 Posted April 19, 2018 Share Posted April 19, 2018 What is the Jars U added in lib folder Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now