Hi,
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.
Plz suggest some solution.
