topic Re: Add empty row into Excel File in Talend Studio

Add empty row into Excel File

Anonymous — Thu, 13 Feb 2014 07:01:14 GMT

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

Re: Add empty row into Excel File

Anonymous — Thu, 13 Feb 2014 08:44:58 GMT

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

Re: Add empty row into Excel File

Anonymous — Thu, 13 Feb 2014 13:10:40 GMT

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