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.