[resolved] Read Excel Row by Row

One Star

[resolved] Read Excel Row by Row

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

Accepted Solutions
One Star

Re: [resolved] Read Excel Row by Row

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

All Replies
Four Stars

Re: [resolved] Read Excel Row by Row

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

Re: [resolved] Read Excel Row by Row

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
One Star

Re: [resolved] Read Excel Row by Row

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

Re: [resolved] Read Excel Row by Row

Hi,
Would you mind sharing your solution with us?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] Read Excel Row by Row

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