title: Exporting a XLS with +80.000 records
body: <p>I'm trying to export a XLS file with +80.000 and I'm getting "net.sf.jasperreports.engine.JRException: The cell cannot be added".</p>
  
  <p>I tried to upper the "MAXIMUM_ROWS_PER_SHEET" but it didn't worked.</p>
  
  <p>This is my code:</p>
  
  <pre><code>ByteArrayOutputStream out = new ByteArrayOutputStream();
  try {
      JasperReport relatorioJasper = (JasperReport) JRLoader.loadObjectFromFile(parametros.get("REPORT_JASPER")+"");
  
      JRBeanCollectionDataSource dataSource = new JRBeanCollectionDataSource(listaReport);
      JasperPrint jasperPrint = JasperFillManager.fillReport(relatorioJasper, parametros, dataSource);
  
      JRXlsExporter exporter = new JRXlsExporter();
      exporter.setExporterInput(new SimpleExporterInput(jasperPrint));
      exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(out));
      SimpleXlsReportConfiguration configuration = new SimpleXlsReportConfiguration();
      configuration.setOnePagePerSheet(false);
      configuration.setDetectCellType(true);
      configuration.setCollapseRowSpan(false);
      configuration.setRemoveEmptySpaceBetweenColumns(true);
      // exporter.setParameter(JRXlsExporterParameter.MAXIMUM_ROWS_PER_SHEET, 10000);
  
      exporter.setConfiguration(configuration);
      exporter.exportReport();
  
  
      InputStream relatorios = new ByteArrayInputStream(out.toByteArray());
      return stream2file(relatorios, parametros.get("REPORT_NAME")+"" ,Constantes.XLS);
  }catch(Exception e){
      e.printStackTrace();
  }
  return null;
  </code></pre>
  
  <p>Can anybody help me? </p>