如何把Excel表格数据转成XML

因为case的管理工具现在要使用开源工具testlink,这就导致如何移植历史数据的问题。之前case管理工具是devtest，可以export excel格式的用例，但是testlink只能import XML的数据。如何能把EXCEL转成XML，我自己试了一下。

首要的步骤是创建mapped ranges（mapped range: A range in an XML list that has been linked to an element an XML map.）

Steps:

1.       If the Developer tab is not available, do the following to display it:

1.       Click the Microsoft Office Button , and then click Excel Options.

2.       In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

2.       On the Developer tab, in the XML group, click Source.

The XML Source task pane is displayed.

3.       To map one or more elements to your worksheet, select the elements in the XML Source task pane. To select nonadjacent elements, click one element, and then hold down CTRL and click each element.

4.       Drag the selected elements to the worksheet location where you want them to appear.

Note:这就涉及一个问题，首先要找好XML source文件，我的做法是在testlink创建一个test case，然后export，用这个XML文件作为source。