tailorbird.restless Posted March 19, 2014 Share Posted March 19, 2014 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) Link to comment Share on other sites More sharing options...
hozawa Posted March 19, 2014 Share Posted March 19, 2014 Seems like something in the following thread. Which version of JasperReports are you using?http://stackoverflow.com/questions/10753562/invalid-row-number-65536-outside-allowable-range-0-65535 Link to comment Share on other sites More sharing options...
tailorbird.restless Posted March 20, 2014 Author Share Posted March 20, 2014 Version : jasperreports-3.7.6 The above link seems not using the JasperReports but the Apache POI. Link to comment Share on other sites More sharing options...
vsairam28 Posted June 18, 2015 Share Posted June 18, 2015 Is this issue got resolved? I am facing this same issue with jasperreports-5.5.1 version. Nevermind,it seems not an issue with Jasper reports. Changed JRXlsExporter to JRXlsxExporter to generate XLSX format instead of XLS. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now