News

Click on the "Data" menu in Excel and choose "XML," then "XML Source" to open the "XML Source" task pane. Click on the "XML Maps" button, then click "Add" and choose the XML map file you created ...
Change XML File: Update the ET.parse() method with the correct path to your XML file. Change Output File: Modify the wb.save() method to set the desired name and path for the generated Excel file.
These two scripts do not round trip - only some of the information in the XML is converted to Excel, and you cannot create arbitrary Archi XML files from Excel. Rather: XML to Excel conversion is ...