https://community.qlik.com/t5/Talend-Studio/outofmemory-error-while-appending-an-excel-file/m-p/2377690#M139501 <P>Hi,</P><P>I am trying to append an already existing excel sheet which has a header with filters and coloring. When I try to append with less data using tfileoutputexcel componet, it gets loaded successfully, but when the data reaches to a huge number, then the job gets failed due to outofmemory issue.</P><P></P><P></P><P>Note: when we directly load a file(do not append) with same data then it gets loaded in very less time. while appending only it causes issues after loading 100000 records. Total number of records is 200000.</P><P></P><P></P><P>Plz suggest some solution.</P> Fri, 15 Nov 2024 23:17:07 GMT achhapre23 2024-11-15T23:17:07Z https://community.qlik.com/t5/Talend-Studio/outofmemory-error-while-appending-an-excel-file/m-p/2377690#M139501 <P>Hi,</P><P>I am trying to append an already existing excel sheet which has a header with filters and coloring. When I try to append with less data using tfileoutputexcel componet, it gets loaded successfully, but when the data reaches to a huge number, then the job gets failed due to outofmemory issue.</P><P></P><P></P><P>Note: when we directly load a file(do not append) with same data then it gets loaded in very less time. while appending only it causes issues after loading 100000 records. Total number of records is 200000.</P><P></P><P></P><P>Plz suggest some solution.</P> Fri, 15 Nov 2024 23:17:07 GMT https://community.qlik.com/t5/Talend-Studio/outofmemory-error-while-appending-an-excel-file/m-p/2377690#M139501 achhapre23 2024-11-15T23:17:07Z https://community.qlik.com/t5/Talend-Studio/outofmemory-error-while-appending-an-excel-file/m-p/2377691#M139502 <P>Hello,</P><P>Please refer to this KB article about OutOfMemory Exception to see if it works for you.</P><P><A href="https://community.talend.com/s/article/OutOfMemory-Exception-WmtmQ" alt="https://community.talend.com/s/article/OutOfMemory-Exception-WmtmQ" target="_blank">https://community.talend.com/s/article/OutOfMemory-Exception-WmtmQ</A></P><P>Best regards</P><P>Sabrina</P> Mon, 24 Jan 2022 04:02:59 GMT https://community.qlik.com/t5/Talend-Studio/outofmemory-error-while-appending-an-excel-file/m-p/2377691#M139502 Anonymous 2022-01-24T04:02:59Z