yaghwin

thnx csmth i tried wt u suggested bt the problem still remains. my table at this moment consists of 23000 records and it will grow each day. the generated xls file of 11 mb size. but when i open the file it says file contains unreadable data.

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

thanx a ton CBox... cheers

Hi Kuldip, can you share the jrxml with me? actually my issue is that i am getting the date with time e.g. 12/05/08 12:00:00 am and i want it like 12/05/2008 only. how can i achieve that. Post Edited by yaghwin bhatti at 12/11/08 12:50