Modifying Font Type in tFileOutputExcel

[Anonymous]

Hi,

I need to decorate my output excel sheet with header in bold and Font type to calibri.How does I achieve this?I could see that we can modify using Apache poi
in Java but how do I integrate this in Talend.Please help.

Thanks,
Mathi

[fdenis]

hi,
you can fill a temlate file it's the best way. just flush data into an formated excel file.

you can also use poi into tjava using output stream or reopening file. but it's not the best way if you want to be industrialised.

good luck.

[Anonymous]

Thanks for the suggestion.

My Output file is dynamic here.I cannot directly format the file and store it.Is there any way I can copy my template file to the output file.

[fdenis]

yes use tfilecopy then fill your excel.
you can implement a case when to select your template.
an other way is to use jasper to buils report from Talend.
Regards