如何使用记事本从xml文件中提取数据？

我有一个带结构的xml响应(例如,组>子组>子记录).

我想将所有childRecord.name的列表提取为单独的数据.我希望我能在记事本中快速做一些事情然后将结果粘贴到excel中.

我不确定如何编写宏可能在这种情况下会为我做这个.

<group>

  <subgroup>

    <childrecord name="abc">zzz</childrecord>

  </subgroup>

</group>

直接使用MS Excel打开XML文件.

更新

从support.office.com开始：

Import an XML data file as an XML table

Click Developer > Import.

If you don’t see the Developer tab,see 07001.

In the Import XML dialog Box,locate and select the XML data file (.xml) you want to import,and click Import.

If the XML data file doesn’t refer to a schema,Excel infers the schema from the XML data file.

In the Import Data dialog Box,do one of the following:

a. Select XML table in existing worksheet to import the contents of the XML data file into an XML table in your worksheet at the specified cell location.

b. Select XML table in new worksheet to import the contents of the file into an XML table in a new worksheet starting at cell A1. The schema of the XML data file is displayed in the XML Source task pane.

If the XML data file doesn’t refer to a schema,then Excel infers the schema >from the XML data file.

To control the behavior of XML data (such as data binding,format,and layout),click Properties,which displays the XML Map properties dialog Box. For example,existing data in a mapped range will be overwritten when you import data by default,but you can change this.

在LibreOffice Calc中导入XML文件：

>从菜单栏中,转到数据> XML源代码……>单击浏览按钮(文件夹图标),然后从对话框中选择文件>选择所需的节点>填写Mapped单元格字段,例如A1>单击“导入”按钮.

如何使用记事本从xml文件中提取数据？

猜你在找的XML相关文章