Jump to content
Changes to the Jaspersoft community edition download ×

How add sheet to xls report?

Recommended Posts

By: Sonia Marcela Benavides - sobenavi

How add sheet to xls report?

2003-03-18 07:37

I'm creating a report and exporting a file with xls format.. there a property called IS_ONE_PAGE_PER_SHEET in the JRXlsExporterParameter class wich add a sheet for every page in the report.


How can i decide when add a sheet, like having groups of pages and i decide when generate a new sheet.... how can add sheets in jasper reports?


Thanks a lot





By: Teodor Danciu - teodord

RE: How add sheet to xls report?

2003-03-25 14:10




The built-in XLS exporter creates exactly one sheet

per page, in the original document.

I cannot create one sheet for multiple pages.

There is a one-to-one relation.


Page breaks can be forced using

the "isStartNewPage" attribute of the group.


But there is no way you could prevent a group from

overflowing on multiple page and resulting in more

than on sheet.

Which brings me to this idea: Use a fairly large

enough page height to make sure no group will

spread across more than one page and this way

you'll have a page break only when your group


But this is a trick that I don't think was tested

before and is not very nice.


I hope this helps.


Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...