Talend output into a formatted excel format

[JSey]

Hi

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)?

[kakooo16]

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

[gjeremy1617088143]

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

[JSey]

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

[Ganshyam]

Hi ,

Please use the talend custom component available in talend exchange.

tfileexcelsheetoutput will solve your purpose.

Regards