One Star

tFileOutputExcel not appending sheets to a file

Hi, 
I have two tfileoutputexcel components under the same subjob connected one to a removeblanks component and the other one to a removedup component. I'm trying to send the info of rejected record from both components to the same file. I have the options to append existing file selected in both tfileoutputexcel however is not appending the sheet for the duplicates. See image below of the subjob
2 REPLIES
One Star

Re: tFileOutputExcel not appending sheets to a file

huh? me see nothing, I was expecting for a screenshoot
One Star

Re: tFileOutputExcel not appending sheets to a file

Hi,
Select the check box of  Write excel2007,Include header,Appen existing file,Append existing sheet  in component properties in both tfileoutputexcel component.
See below image:

Thanks,
kumar