I have a size 11.9 MB excel and talend won't load and will crash in the middle of it.
I already changed my TOS_DI-win-x86_64.ini settings to increase talend memory, but it still the same.
Are you getting "OutofMemory" error when try to load a large size of excel? Have you tried to allocate more memory to your active job instead of the whole studio?
Here is a KB article about:https://community.talend.com/t5/Migration-Configuration-and/OutOfMemory-Exception/ta-p/21669
Feel free to let us know if this solution is OK with you.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables