hi all, i am trying to export my report into xls format but when i open the generated file i get the error saying "Excel file contains unreadable data" and if it tries to recover the file the formatting in the file is haywire. it happens when the records are around 4000-5000 is there a limitation as in how many records it supports? any idea as to why its happening and how it can be rectified. my code is JRXlsExporter xls=new JRXlsExporter(); ByteArrayOutputStream output = new ByteArrayOutputStream(); OutputStream outputfile= new FileOutputStream(new File(path+"\output\"+reportname+".xls")); xls.setParameter(JRXlsExporterParameter.JASPER_PRINT, jasperPrint); xls.setParameter(JRXlsExporterParameter.OUTPUT_STREAM,output); xls.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE); xls.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,Boolean.TRUE); // xls.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE); xls.setParameter(JRXlsExporterParameter.MAXIMUM_ROWS_PER_SHEET,Integer.decode("65000")); xls.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE); xls.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE); xls.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE); System.out.println("Before Exporting to XLS"); xls.exportReport(); thanx