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: