matth33 Posted September 26, 2011 Share Posted September 26, 2011 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 Link to comment Share on other sites More sharing options...
matth33 Posted September 27, 2011 Author Share Posted September 27, 2011 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 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now