Thanks for help me. I am Simon from Dalian China, I like vba programming, but I am new. Now I have one requirement to convert data in csv file to xml file.
The data in CSV file as below:
<tbody>
</tbody>
<colgroup><col></colgroup><tbody>
</tbody>
Anyone can give me some advise? or sample code? Thanks a lot!!!
The data in CSV file as below:
| Detail Key | Bookable Rev ($K) | Seller Name | Roadmap | Brand | IOT | IMT | Sector |
| 12KY-1V1NSVB | 5 | abc | SS | S | TEST | CH | TTT |
| 12KZ-FDXR7E | 5 | bcd | SS | S | TEST | CH | TTT |
| 1JF-262SCZ2 | 4 | bcd | NIR | S | TEST | CH | TTT |
| 1JF-258QBIA | 3.1 | bcd | SS | S | TEST | CH | TTT |
<tbody>
</tbody>
| <?xml version="1.0" encoding="UTF-8" ?> |
| - <dataset xmlns="test" xmlns:atom="test"> |
| - ******data> |
| <item name="Detail Key" type="xs:string" length="256" /> |
| <item name="Bookable Rev " type="xs:int" /> |
| <item name="Seller Name" type="xs:string" length="256" /> |
| <item name="Roadmap" type="xs:string" length="256" /> |
| <item name="Brand" type="xs:string" length="256" /> |
| <item name="IOT" type="xs:string" length="256" /> |
| <item name="IMT" type="xs:string" length="256" /> |
| <item name="Sector" type="xs:string" length="256" /> |
| *******data> |
| - <data> |
| - <row> |
| <value>12KY-1V1NSVB</value> |
| <value>5</value> |
| <value>abc</value> |
| <value>SS</value> |
| <value>S</value> |
| <value>TEST</value> |
| <value>CH</value> |
| <value>TTT</value> |
| </row> |
<colgroup><col></colgroup><tbody>
</tbody>
Anyone can give me some advise? or sample code? Thanks a lot!!!
Last edited:
