Hello All,
You can only dump maximum 10,48,576 rows into ms excel (xlsx) file using talend.
Sample Error MSG:
Exception in component tFileOutputExcel_1
java.lang.IllegalArgumentException: Invalid row number (1048576) outside allowable range (0..1048575)
at org.apache.poi.xssf.streaming.SXSSFSheet.createRow(SXSSFSheet.java:107)
You can only dump maximum 10,48,576 rows into ms excel (xlsx) file using talend.
Sample Error MSG:
Exception in component tFileOutputExcel_1
java.lang.IllegalArgumentException: Invalid row number (1048576) outside allowable range (0..1048575)
at org.apache.poi.xssf.streaming.SXSSFSheet.createRow(SXSSFSheet.java:107)