Tuesday, March 22, 2016

xlsx file limit in Talend

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)

No comments:

Post a Comment