Converting Excel data to XML

You may want to use the XML when you create level design and save the scene. However, it is difficult to fix directly by hand.

Even when I was working plist in Xcode, it was difficult for the same reason as this. I do not want to work about plist again.

I hate also be considered.

In such this work, Excel is very useful.

Let write an post about how to using Excel and how to convert to XML .

The first thing most, will launch a new Notepad.

And you must create two of the minimum required to create a node configuration of the XML you want to create.
As shown below.

The following figure is what you have created a data that has two columns of text and id.

Change the extension to XML now and save. (Write like test.xml.)

And please the order shown in the figure below.

Then, the menu in the menu tab called "Developer" comes out.
Here, you will want to work with the "Import" and "Export" as shown below.

Now, create a new document. And use the 'Import' button,  please open "test.xml".

Message box appears. Please press OK.

if you see as in the figure below, you are success.

Please select the desired location. because When you push "Import" button, appeared currently location.

Now you modify the document to put the desired data. And push "Export" button under 'Import' button.


If open the saved file, you will know that the data is inserted correctly.