topic Re: Talend output into a formatted excel format in Talend Studio

Talend output into a formatted excel format

JSey — Mon, 10 May 2021 18:23:42 GMT

I have a project where the requirement is to output data into a formatted .xlsx excel template with colours and sorting and multiple tabs. Is this possible with tfileoutputexcel? How would I do this (append the data to a pre-existing file template with all the excel formatting)?

Re: Talend output into a formatted excel format

kakooo16 — Tue, 11 May 2021 07:33:56 GMT

Maybe tick the append to an existing Excel file case in tfileoutputexcel ?

Re: Talend output into a formatted excel format

gjeremy1617088143 — Tue, 11 May 2021 13:44:43 GMT

Hi i don't think its possible with tfileoutputexcel, maybe you can find components wich do this on talend exchange.

Send me Love and Kudos

Re: Talend output into a formatted excel format

JSey — Tue, 11 May 2021 20:37:39 GMT

Can I use append if there are multiple work sheet within the excel document?

Re: Talend output into a formatted excel format

Ganshyam — Thu, 27 May 2021 05:21:23 GMT

Hi ,

Please use the talend custom component available in talend exchange.

tfileexcelsheetoutput will solve your purpose.

Regards