| sanketgroup |
| Newbie |
|
| US |
|
|
| None Specified |
|
| Saturday, January 2, 2021 |
| Sunday, January 3, 2021 5:34:23 AM |
1
[0.01% of all post / 0.00 posts per day] |
|
Hello,
I want to convert Excel data to XML format as shown below.
My excel file has data something like below.
+----+--------+--------+------+-------+
| ID | Name | ItemSr | Item | Price |
+----+--------+--------+------+-------+
| 1 | Peter | 1 | A | 100 |
| 1 | Peter | 2 | B | 200 |
| 2 | Thomas | 1 | A | 300 |
+----+--------+--------+------+-------+
And I want to convert it to XML like below.
Code:<SampleMESSAGE xmlns:UDF="SampleUDF"> <Voucher.List> <VOUCHER> <Name>Peter</Name> <Item.LIST> <Item>A</Item> <Amount>100</Amount> <Item>B</Item> <Amount>200</Amount> </Item.LIST> </VOUCHER> <VOUCHER> <Name>Thomas</Name> <Item.LIST> <Item>A</Item> <Amount>300</Amount> </Item.LIST> </VOUCHER> </Voucher.List> </SampleMESSAGE>
Please help.
Thanks
|
|
