topic Re: tFileOutputExcel not appending sheets to a file in Talend Studio

tFileOutputExcel not appending sheets to a file

Anonymous — Thu, 29 Jan 2015 14:01:39 GMT

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

Re: tFileOutputExcel not appending sheets to a file

Jcs19 — Thu, 29 Jan 2015 14:07:57 GMT

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

Re: tFileOutputExcel not appending sheets to a file

Anonymous — Fri, 30 Jan 2015 14:36:53 GMT

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