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.
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.
