java.lang.NoSuchMethodError:org.apache.poi......

[spmkkmps]

hi

When 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();		}	}

[spmkkmps]

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.

[satishp_1]

What is the Jars U added in lib folder