如何将所有 XML 文件转换为 XML 对象?

问题描述

我们如何使用 PowerShell 将多个 XML 文件转换为对象?

How can we use PowerShell to cast multiple XML files to objects?

假设我们有一个 XML 文件目录

Suppose we have a directory of XML files

$xmlfiles = Get-ChildItem C:\Directory -Filter *.xml

foreach ($file in $xmlfiles) {
  [xml]$file Get-Content $_
}

我不知道如何继续 - 如果我们想在每个文件通过时查询它，我们是否需要嵌套的 foreach?

I am not sure how to proceed - if we want to query each file as it passes, do we need a nested foreach?

我只是转换为 XML 以在多个文档之间进行简单查询.我的所有文档都具有相同的架构，我想从每个文档中选择一组一致的节点和属性.

I am only casting as XML to make simple queries across multiple documents.All of my documents have identical schema and I want to select a consistent set of nodes and attributes from every document.

我已经按照评论中的建议尝试了

I have tried as suggested in the comments

foreach ($file in $xmlfiles) {
  Select-Xml $file -Xpath "//node2"
}

但我收到运行时异常:

Cannot convert value "sample-document.xml" to type "System.Xml.XmlDocument". Error:
"The specified node cannot be inserted as the valid child of this node, because the
specified node is the  wrong type."
At line:1 char:10
+ foreach ($file in $xmlfiles) {
+          ~~~~~
    + CategoryInfo          : MetadataError: (:) [], ArgumentTransformationMetadataException
    + FullyQualifiedErrorId : RuntimeException

推荐答案

如评论中所建议，您可以使用 Select-Xml cmdlet 直接针对文件运行 XPath 查询.

As suggested in the comments, you can use the Select-Xml cmdlet to run XPath queries directly against files.

您可以通过管道将 FileInfo 对象从 Get-ChildItem 直接传送到 Select-Xml:

You can pipe FileInfo objects from Get-ChildItem directly to Select-Xml:

Get-ChildItem C:\Directory -Filter *.xml |Select-Xml -XPath '//node2'

如果您需要使用 ForEach-Object 或循环进行进一步处理，请将文件的 FullName 属性提供给 Select-Xml:

If you need to use ForEach-Object or a loop to do further processing, supply the FullName property of the file to Select-Xml:

foreach($xmlFile in Get-ChildItem C:\Directory -Filter *.xml){
    $QueryResult = Select-Xml -Path $xmlFile.FullName -XPath '//node2'
}

这篇关于如何将所有 XML 文件转换为 XML 对象?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！