print all data in one page (only for xls)

[miodas007]

Hi,

i wont print all data in one page for .xml (for .pfd with page division). I try (for .xls export):

jex.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
jex.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);

But, in this way i have repetitive Colum Header.

Is diffrent way to showing all data in one page or to delete Colum Header (without 1-st page Column Header) ?

[miodas007]

any idea?

[Giulio Toffoli]

There is no way to do that only for a specific exporter once the JasperPrint has been created.

But if you plan to export a report only in Excel, you can run the report usign the IGNORE_PAGINATION setting.

 

Giulio