Configuring in Excel Using XML templates

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.