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.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.