Exports the Multiple excel Sheets in single Excel file using single JRXML

[supriyat32882]

I have created a JRXML with 5 tables so I want to create different sheets in the excel file according to the order of the tables.

Sheets are created as expected but the problem is that if the data table has more than 27 rows then a new sheet will be created.

So I expect that only one table will create only one sheet with any no of data.

E.g. In case 1 table with 1000 records and another table with 20 records only two sheets should be created one with 1000 records and another with 20 records.

Please suggest!!!

Filterd User List_12-Dec-2023-15-41-3054.xlsx

[Mehak Rajkumar]

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.
 

[shreekrishna.shankhwar]

https://shreekrishnashankhwar.wordpress.com/2023/12/17/jasper-create-excel-with-multiple-sheets/

Please try to set these properties as per above link that should work. I have create a this kind of report. 

Please try once to solve your issue.

 

[rpachipu]

Hi ,

1.You can the add the below property to the report.
net.sf.jasperreports.export.xls.one.page.per.sheet="false"

2. Identify the report element i.e, textbox  where you want to cut the page  before or after. Based on that, you can cut the page by adding the one of the below property to the textbox.

net.sf.jasperreports.export.xls.break.before.row="true"
net.sf.jasperreports.export.xls.break.after.row="true"

 

or you can do the step 2 form UI as below: