Repeating column header on excel export with multiple sheets

[matth33]

Hi guys,

I need to generate a huge excel report. I want to limit the number of data per sheet with 65000.

So i use this parameters :

 JRXlsExporter exporter = new JRXlsExporter();
exporter.setParameter(JRXlsExporterParameter.MAXIMUM_ROWS_PER_SHEET, 65000);
exporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);
exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
exporter.setParameter(JRXlsExporterParameter.IS_FONT_SIZE_FIX_ENABLED, Boolean.TRUE);
exporter.setParameter(JRXlsExporterParameter.IS_IGNORE_CELL_BORDER, Boolean.FALSE);
exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE); exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.FALSE) ;

Separating data in several sheets works fine. But, i want to repeat the column header if the number of rows exceeds JRXlsExporterParameter.MAXIMUM_ROWS_PER_SHEET and that does't not work.

 

Could you please help me.

Thanks

[matth33]

I find a solution using group and making break each 65000 rows. It's not very confortable to use.

 Is there another way to proceed ?

Thanks