XLSX Export Page Header in New Sheet

[Balraj]

Hi community,

I've working on a report wherein when I Export it to XLSX, PAGE HEADER of the report should be printed in "Sheet 2" of Excel.

Any Inputs Highly Appreciable :)

Thanks & Regards

JasperExplorer

[hozawa]

If you're exporting to Excel, it's better to set the following property to set the header in spreadsheet instead of trying to use report header. Just disable the report header off when exporting to Excel and allow the following property to set Excel header instead.

http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.xls.sheet.header.center

[Balraj]

Hi @hozawa,

The Page Header is Dynamic, in the suggested case it'll be only static. 

Page Header contains report RunTime and the User Input Selection Values.

Is there any other approach to solve this?

Thanks :)

 

 

[Balraj]

Hi I solved it, by using "net.sf.jasperreports.export.xls.break.before.row" = true

on all the elements in the PageHeader band

Thanks for Support :)