This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes Other Open Source Projects and the fly likes iReport excel export to exclude page header and page footer [Urgent] Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "iReport excel export to exclude page header and page footer [Urgent]" Watch "iReport excel export to exclude page header and page footer [Urgent]" New topic
Author

iReport excel export to exclude page header and page footer [Urgent]

Mary Koh
Ranch Hand

Joined: Feb 19, 2012
Posts: 33
Hi,

I am using iReport and would like to export it to excel without page header and page footer.
How can I accomplish this? I would like to add it to my java codes.

For detecting cell type, it is as follow..
Jrxml: <property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>
Java: xlsExporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);

How about export without page header and footer?
Jrxml: <property name="net.sf.jasperreports.export.xls.exclude.origin.band.1" value="pageHeader"/>
Java: ???

 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: iReport excel export to exclude page header and page footer [Urgent]