Export to excel with single sheets

[mauro.correa.nunes]

I'm trying to export to excel in single sheets, but the speakers are going wrong and the header is repeating.

is there any way to export without the header?

[cennettatil]

to save a single sheet only you need to copy the sheet to another workbook and save the new workbook.

to enable what you want with autoupdating then you should
1. make sure calculations are set to manual
2. run the sheet calculation fxn(tools/options/calulation/calculate sheet) when you are in the neccesary sheet to be updated.

[Ankur Gupta]

Hi mauro,

If you want to export the report in the excel file exclusively , then what you can do is follow these steps:

• Firstly, click on the node column header , in the properties you would be able to see the property PrintWhenExpression , click on that and enter the expression as $V{PAGE_NUMBER}==1, this would serve a solution to the problem of the repeating headers, headers will be displayed only once.
• Next is that you would not want the page footers(if present), to be repeating so same PrintWhenExpression could be put up as $V{PAGE_NUMBER}==1
• You could put this printWhenExpression for any element ,  and specify the condition for its appearance , pretty handy property

Hope that this helps .

 

Thanks,

Ankur

[Thomas Zimmer]

You could have activated "No Pagination" if you export your report to xls only.

Otherwise, use jasperreports properties: http://jasperreports.sourceforge.net/config.reference.html 

You will need

net.sf.jasperreports.export.{format}.exclude.origin.{suffix}.{arbitrary_name}

and possibly 

net.sf.jasperreports.export.{format}.exclude.origin.keep.first.{suffix}.{arbitrary_name}

to supress single bands in specific output formats.

Cheers, Thomas

http://www.thomaszimmer.net