PDA

View Full Version : XLSX to XML Macro



tanmay2501
07-01-2019, 10:43 AM
Can anyone help me out with XLSX to XML macro that converts the sheet 1 data to XML file
For eg :-
File contains
Col 1 Col 2
Row 1 School\ Name School\City
Row 2 Xavier. Delhi

XML file after conversion


<School>
<Name>Xavier</Name>
<City>Delhi>/City>
<\School>


I would be very very greatful to you