1, first create a template to define the XML format, using a text editor to enter the following text, and save in XML format, such as: Template.xml
<?xml version= "1.0" encoding= "Utf-8"?>
<ROOT>
<!--Content--
<table wave= "" Enemyname= "" level= "" wait= ""/>
<table wave= "" Enemyname= "" level= "" wait= ""/>
</ROOT>
Note that we have defined two columns of table, which is required so that you can map data elements in bulk in Excel.
2. Start Excel, right-click on the Excel toolbar, and select "Customize Quick Access Toolbar"
3. In the Customize ribbon--"Main tab" select "Development Tools"
650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/79/CA/wKiom1abAXXASICQAANEY89M5nc585.jpg "title=" QQ picture 20160117104926.jpg "alt=" wkiom1abaxxasicqaaney89m5nc585.jpg "/>4", select "Source" On the Developer tab
650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/79/C9/wKioL1abAl3xhuLCAAA_MbFMiUI064.png "title=" QQ picture 20160117105246.png "alt=" Wkiol1abal3xhulcaaa_mbfmiui064.png "/>
5. Select "XML map" below the XML source window and choose to add the template file before opening Template.xml
650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/79/CA/wKiom1abAuXg3LAhAABSspNzPTs428.png "title=" QQ picture 20160117105603.png "alt=" Wkiom1abauxg3lahaabsspnzpts428.png "/>
6. Add text in Excel with the name consistent with the XML template
650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M02/79/CA/wKiom1abA2qwSR3MAABl83-UKWA635.png "title=" QQ picture 20160117105808.png "alt=" Wkiom1aba2qwsr3maabl83-ukwa635.png "/>
7, in the XML source, select Tabel below wave,enemyname,level,wait, to excel in the corresponding text table
and enter the corresponding value
650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/79/C9/wKioL1abBLCzjyFFAABqAQzAgVI313.png "title=" QQ picture 20160117110117.png "alt=" Wkiol1abblczjyffaabqaqzagvi313.png "/>8 in order to avoid enemyname input errors, you can select data validation in the Data tab and Allow to select the sequence, and then enter all the names of the enemies in source, separated by commas. So the table can only use the default name
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/79/CA/wKiom1abBXXS4wr8AABQlA6vzWs098.png "title=" QQ picture 20160117110702.png "alt=" Wkiom1abbxxs4wr8aabqla6vzws098.png "/>
9, finally save Excel as XML format, into Xmltext.xml, content similar to the following format:
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/79/CA/wKiom1abBeTiuYhPAAAmX0h5_wk381.png "title=" QQ picture 20160117110859.png "alt=" Wkiom1abbetiuyhpaaamx0h5_wk381.png "/>
Configuring in Excel Using XML templates