One Star

Add empty row into Excel File

Hello,
I have set of XML files. I want to convert all XML files into a single Excel file. I done this job with tFileList -> tFileInputXML -> tFileOutputExcel.
Now I want add an empty row in Excel after reading each XML file. But I don't know how to do with talend.
Please help me.
Thanks
Iyyappan S
2 REPLIES
Community Manager

Re: Add empty row into Excel File

use a tFixedFlowInput to generate a empty row and append it to an existing Excel file, for example:
tFileList -iterate> tFileInputXML -main--> tFileOutputExcel_1--oncommponentOK-->tFixedFlowInput--main--tFileOutputExcel_2
tFixedFlowInput, define one column and set its value as ""
tFileOutputExcel_1 and tFileOutputExcel_2, check the 'Append existing file' and 'Append existing sheet' box.
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Add empty row into Excel File

Hi Shong,
Thank u very much for your answer and quick response. I run my job as per your suggestion, it works as expected.
Thanks
Iyyappan S