I was trying to write an excel sheet and then download the same using byteArray. I have almost 1L records and is getting the following error. Invalid row number (65536) outside allowable range (0..65535) try { List<byte[]> byteArray = new ArrayList(); for (ReportGen reportGen : reportGenOutputs) { JasperPrint jasperPrint = (JasperPrint)reportGen.getContent(); ByteArrayOutputStream outStr = new ByteArrayOutputStream(); JRXlsExporter XLSExp = new JRXlsExporter(); XLSExp.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); XLSExp.setParameter(JRExporterParameter.OUTPUT_STREAM, outStr); XLSExp.setParameter(JRXlsAbstractExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE); XLSExp.exportReport(); byteArray.add(outStr.toByteArray()); } return byteArray; } catch (Exception e) { // Exception goes here }[/code] Invalid row number (65536) outside allowable range (0..65535)Invalid row number (65536) outside allowable range (0..65535)
