title: Exceeding the row limit of 65536 in Excel in JasperReports
body: <p>While hitting the database I am getting more than 80000 records. I am using JasperReports to export those into an Excel, but an Excel can hold a row limit of 65536. </p>
  
  <p>How can I export all records in single report or how can I create a new excel when ever it exceeds 65536? I gone through this link but I am not getting things:
  <a href="https://stackoverflow.com/questions/197762/is-it-possible-to-see-more-than-65536-rows-in-excel-2007">Is it possible to see more than 65536 rows in Excel 2007?</a>.</p>
  
  <p>Here is the main problem: list object contains more than 80000 records. How can I divide the list object into two JasperPrint objects when ever it exceed the 65536 rows? </p>
  
  <p>If i am able to divide the list object into two JasperPrint objects then we can happily add the two <code>JasperPrint</code> objects to one collection then we can add the collection object to <code>JRExporter</code> object here is the code to add two <code>JasperPrint</code> objects to collection:
     <a href="https://stackoverflow.com/questions/3977658/how-do-you-export-a-jasperreport-to-an-excel-file-with-multiple-worksheets">How do you export a JasperReport to an Excel file with multiple worksheets?</a>.</p>
  
  <p>This is my code so far:</p>
  
  <pre><code>JRDataSource datasource = new JRBeanCollectionDataSource(
                              confirmList);
                      JasperReport jasperReport = (JasperReport) JRLoader
                              .loadObject(reportPath);
                      Map parameters = new HashMap();
                      parameters.put("title", "Reports for "
                              + "confirmed");
                      JasperPrint jasperPrint = JasperFillManager.fillReport(
                              jasperReport, parameters, datasource);
  </code></pre>
  
  <p>Can anyone please guide me how to do this?</p>