Generate ExcelSheet Data with Header and Merged Cell + Append actual data

Anonymous — Sat, 16 Nov 2024 03:33:41 GMT

Team,

I am new to Talend and started to use Talend to pull data from the sharepoint list using SOAP, tXMLOutput, XMLMAP. I have to write my output in an excel sheet with the below format.

I mean I just need to start to write data after the 2nd row.

My Requirements:

1) Header with Background Color

2)Text with Background color as well Merged in the center

3) Start to Write Data from the sharepoint output

Is it possible?

topic Generate ExcelSheet Data with Header and Merged Cell + Append actual data in Talend Studio

Generate ExcelSheet Data with Header and Merged Cell + Append actual data