topic Re: Modifying Font Type in tFileOutputExcel in Talend Studio

Modifying Font Type in tFileOutputExcel

Anonymous — Tue, 26 Mar 2019 04:18:15 GMT

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

Re: Modifying Font Type in tFileOutputExcel

fdenis — Tue, 26 Mar 2019 07:44:37 GMT

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.

Re: Modifying Font Type in tFileOutputExcel

Anonymous — Wed, 27 Mar 2019 03:53:20 GMT

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.

Re: Modifying Font Type in tFileOutputExcel

fdenis — Thu, 28 Mar 2019 10:47:14 GMT

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