Formatting Excel file using talend

[Anonymous]

Hi,

I need to create a report using talend. So far I was able to create a simple excel file but it has just data printed. I mean, it doesn't have any formatting to the columns or tables. 

I need to have borders to the columns or background color to the titles kind of formatting.

Is there any way to do this in talend? 

Regards,

Bhagwat

[Martintin]

Hi @bhagwatn ,

It's not possible with the built-in excel components but you can find some in talend exchange that do what you want.

For further information check this link : 

https://community.talend.com/t5/Design-and-Development/Apply-background-color-in-tFileOutputExcel/td...

The link of the talend exchange components :

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%...

Regards,

Martin

[Anonymous]

Hi @mhodent, 

I have already downloaded the components you mentioned. 

But could you please elaborate on how to use them as per my requirements.

Thanks,

Bhagwat

[Martintin]

At the moment, I don't know how to do what you want. I never really used them.

But if we refer to the documentation of the component :

https://jan-lolling.de/talend/components/help/tFileExcelSheetOutput.pdf

In scenario 4, it seems that you have to create a sample file with what your file should look like

and import it as a template.

Regards,

Martin