Jump to content
Changes to the Jaspersoft community edition download ×

JRXlsExporter - Invalid row number (65536) outside allowable range


tailorbird.restless

Recommended Posts

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

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

  • 1 year later...

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...