Jump to content

  • Jasper 3.0 error if number of records in xls file is more than 65000

    foreverarpan

    By foreverarpan

     Share
    Assigned User shertage
    CategoryGeneral
    Component: 14539
    PriorityNormal
    ReproducibilityAlways
    ResolutionNo Change Required
    SeverityMinor
    StatusClosed
    Versionv3

    Hi,

    We know that Excel 2007 or Excel 2010 supports max 1,048,576 records in one sheet.

    When we are trying to create .xls file using jasperreports-3.0 version. The excel files has more than 65000 records in one sheet.

    But we are getting error as below. Please let us know how can we create such xls report.

     

     

     

    Kindly find below the error message:

     

    May 11, 2020 7:49:08 AM com.infy.finacle.finrpt.utils.FinLogger logException

    SEVERE: Error generating XLS report : gl060dp001

    at net.sf.jasperreports.engine.export.JExcelApiExporter in setRowHeight at line:285

    at net.sf.jasperreports.engine.export.JRXlsAbstractExporter in exportPage at line:513

    at net.sf.jasperreports.engine.export.JRXlsAbstractExporter in exportReportToStream at line:434

    at net.sf.jasperreports.engine.export.JRXlsAbstractExporter in exportReport at line:197

    at com.infy.finacle.finrpt.processor.FinRptFactory in exportReport at line:-1

    at com.infy.finacle.finrpt.processor.FinRptFactory in createReportStream at line:-1

    at com.infy.finacle.finrpt.processor.FinFlatFileRptProcessor in process at line:-1

    at com.infy.finacle.finrpt.FinRptSrvr in processMessage at line:-1

    at com.infy.bbu.limos.LiSrvr in runListening at line:-1

    at com.infy.bbu.limos.LiSrvr in run at line:-1

    Caused by: jxl.write.biff.RowsExceededException: The maximum number of rows permitted on a worksheet been exceeded

    The maximum number of rows permitted on a worksheet been exceeded

    at jxl.write.biff.WritableSheetImpl in getRowRecord at line:975

    at jxl.write.biff.WritableSheetImpl in setRowView at line:1224

    at jxl.write.biff.WritableSheetImpl in setRowView at line:1194

    at net.sf.jasperreports.engine.export.JExcelApiExporter in setRowHeight at line:281

    at net.sf.jasperreports.engine.export.JRXlsAbstractExporter in exportPage at line:513

    at net.sf.jasperreports.engine.export.JRXlsAbstractExporter in exportReportToStream at line:434

    at net.sf.jasperreports.engine.export.JRXlsAbstractExporter in exportReport at line:197

    at com.infy.finacle.finrpt.processor.FinRptFactory in exportReport at line:-1

    at com.infy.finacle.finrpt.processor.FinRptFactory in createReportStream at line:-1

    at com.infy.finacle.finrpt.processor.FinFlatFileRptProcessor in process at line:-1

    at com.infy.finacle.finrpt.FinRptSrvr in processMessage at line:-1

    at com.infy.bbu.limos.LiSrvr in runListening at line:-1

    at com.infy.bbu.limos.LiSrvr in run at line:-1

     

     Share
    Go to bugs

    User Feedback

    Recommended Comments

    shertage

    Hi,

     

    If possible, please upgrade the JasperReports library to the current version. This way you can export the report to the Excel 2007 or Excel 2010 output format using the JRXlsxExporter (available from v.3.5.3).

     

    In case the upgrade is not an option, you could set the following property in the report with an appropriate value (less than 65000):

    http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.xls.max.rows.per.sheet

    When this number of rows is completed on a sheet, a new sheet will be created to contain the remaining rows.

    Link to comment
    Share on other sites


    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...

© 2023 Cloud Software Group,
Inc. All rights reserved

Products

Explore