[resolved] Read Excel Row by Row

[_AnonymousUser]

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

[Anonymous]

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

[_AnonymousUser]

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

[_AnonymousUser]

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

[Anonymous]

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

[_AnonymousUser · Accepted solution]

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