Search code examples
jasper-reportsexport-to-excel

How to create excel report dynamically with multiple sheets using ireport

I want to create excel report dynamically which has multiple sheet is it possible to create using iReport 4.5.0?

Solution

  • Yes.

    It is possible to create multiple sheets dynamically.

    Use iReport properties field

    net.sf.jasperreports.export.xls.break.after.row

    Custom element property specifying if a sheet will break after the row displaying that element. It is very useful especially when displaying each report's group on a separate sheet is intended.

    for full list of property fields how to use property. visit this page

    Complete API of property can be found here(Reference) and here(Index)