Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, Can someone help me with this requirement.
I have a requirement to load 2 million rows into an excel file. Since excel sheet limit is around 1 million, I would like to load first million into sheet 1 and next million rows into Sheet 2. And Sheet 3 if there are more than 2 million rows in future.
I am using Talend 6.5.1X version
Thank you in advance
Regards
Hello TRF,
I tried your solution. I am still getting error Invalid row number (1048576) outside allowable range (0..1048575)
Am I missing some setting? Please look into the attachment.
Can you provide me the solution to iterate multiple files into multiple sheets. or provide link to any existing solution.
Hello TRF,
I tried your solution. I am still getting error Invalid row number (1048576) outside allowable range (0..1048575)
Am I missing some setting? Please look into the attachment.
Can you provide me the solution to iterate multiple files into multiple sheets. or provide link to any existing solution.
Thank you TRF. This solution is working.
Changed the sheet name to dynamic.