How add sheet to xls report?

[2006 IR Open Discussion]

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

 

Hi,

 

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

starts.

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

before and is not very nice.

 

I hope this helps.

Teodor