i dont knw whether this is te right answer but try JExcelApiExporter to export it to xls file.First i used JRXlsExporter ,it has some data loss on large data.so i tried the JExcelApiExporter .its works fine.u need jasperreports-1.2.7.jar,jxl.jar,png-encoder-1.5.jar to run this. poi-2.0-final-20040126.jar(Additioonal one).i hope this will rectify ur problem