topic [resolved] Read Excel Row by Row in Talend Studio

[resolved] Read Excel Row by Row

_AnonymousUser — Mon, 10 Mar 2014 12:43:39 GMT

Hi,
I have the xml file which has no. of line items for One PO. i have to Place one Sales Order with those no of Line Items. T
For the above problem statement i am using tFileInputXML, and the exporting line items in Excel file. but i am not able to read the Excel file
tFileInputXML->tFileOutputExcel->tWriteXMLField->
How can i read excel file so that i can write all them line items in the xml file and create Sales Order?
Please help.
Regards,
Anurag

Re: [resolved] Read Excel Row by Row

Anonymous — Mon, 10 Mar 2014 13:14:42 GMT

Hi Anurag,
tFileInputXML--main--->tFileOutputExcel--OnSubJobOk-->tFileInputExcel---main-->tWriteXMLField
Try doing this way
Thanks
Vaibhav

Re: [resolved] Read Excel Row by Row

_AnonymousUser — Mon, 10 Mar 2014 13:58:51 GMT

Hi Vaibhav,
Thanks for your reply.
I just tried but still the same output. Only one line item is coming in the xml file generated from tWriteXML component.
I want the all line item in the xml file. I hyave also defined the Item as a loop element in XML tree for tWriteXMlfield
component.
Regards,
Anurag

Re: [resolved] Read Excel Row by Row

_AnonymousUser — Mon, 10 Mar 2014 15:43:15 GMT

After doing some R&D, finally I am done with it.

Re: [resolved] Read Excel Row by Row

Anonymous — Tue, 11 Mar 2014 04:21:55 GMT

Hi,
Would you mind sharing your solution with us?
Best regards
Sabrina

Re: [resolved] Read Excel Row by Row

_AnonymousUser — Tue, 11 Mar 2014 05:25:15 GMT

Please find the solution.
tInputXML---Main-->tFileOutputExcel---Main-->tWriteXMLField
Using this you can read the complete content of excel in xml format.