XLSX Export Page Header in New Sheet

0

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

Balraj's picture
236
Joined: Jan 29 2015 - 7:25pm
Last seen: 2 years 2 months ago

3 Answers:

0

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 :)

Balraj's picture
236
Joined: Jan 29 2015 - 7:25pm
Last seen: 2 years 2 months ago
0

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

hozawa's picture
53210
Joined: Apr 24 2010 - 4:31pm
Last seen: 5 months 1 week ago
0

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's picture
236
Joined: Jan 29 2015 - 7:25pm
Last seen: 2 years 2 months ago
Feedback
randomness