blocks|key|1633657|text|CSS选择器方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1633658|元素的确切CSS选择器是：|1633659|#infoBox+>+div.col-xs-12.thumbnail.thumbnail-more+>+div:nth-child(3)+>+h3|code-block|syntax|javascript|1633660|​|1633661|📷|atomic|offset|length|1633662|1633663|您可以将其简化为：|1633664|1633665|1633666|1633667|甚至是|1633668|1633669|1633670|1633671|获取HTML文档后，可以使用以下任一选择器进行访问：|1633672|.querySelector("#infoBox+>+div.col-xs-12.thumbnail.thumbnail-more+>+div:nth-child(3)+>+h3").InnerText
.querySelector("#infoBox+*>+div:nth-child(3)+>+h3").InnerText
.querySelector(".valueText").InnerText|1633673|1633674|以下是如何使用Internet+Explorer和上面显示的CSS选择器之一提取当前价格($10)的示例：|1633675|代码：|1633676|Option+Explicit

Public+Sub+GetInfo()
++++Dim+IE+As+Object
++++Dim+html+As+Object

++++With+CreateObject("InternetExplorer.Application")
++++++++.Visible+=+True
++++++++.navigate+"https://stashpedia.com/funko/pop-vinyl/thundercats/tygra-exclusive-573"

++++++++While+.Busy+Or+.readyState+<+4:+DoEvents:+Wend

++++++++Set+html+=+.document

++++++++With+html
+++++++++++Debug.Print+.querySelector("#infoBox+*>+div:nth-child(3)+>+h3").innerText
++++++++End+With

++++++++Stop
++++++++'Quit+'<==+Remember+to+quit+application
++++End+With
End+Sub|1633677|关于CSS选择器here的信息。|1633678|1633679|XPath方法：|1633680|如果您想使用上面所示的方法不支持的XPath，您可以使用Selenium+basic，您的脚本可能如下所示：|style|CODE|1633681|Option+Explicit
Public+Sub+GetInfoSel()
++++Dim+d+As+WebDriver
++++Set+d+=+New+ChromeDriver
++++Const+URL+=+"https://stashpedia.com/funko/pop-vinyl/thundercats/tygra-exclusive-573"

++++With+d
++++++++.Start+"Chrome"
++++++++.Get+URL
+++++++Debug.Print+.FindElementByXPath("//*[@id=""infoBox""]/div[1]/div[3]/h3").Text
++++++++'Quit
++++End+With
End+Sub|1633682|注意:下载并安装后，您需要转到VBE中的工具>引用，并添加对Selenium类型库的引用|1633683|1633684|1633685|1633686|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/5014e3d7b88e87fbb5ebbf0c403e8093.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/ea8f98a318ad4dbb6a55fd8bb9688529.png|2|https://ask.qcloudimg.com/http-save/yehe-900000/4f054c8960a89b36b1419ce792a64b16.png|3|LINK|MUTABLE|url|https://developer.mozilla.org/en-US/docs/Web/CSS/CSS_Selectors|4|http://florentbr.github.io/SeleniumBasic/|5|https://ask.qcloudimg.com/http-save/yehe-900000/211dea7cf46c697ab1002e497c8221ba.png^0|0|0|0|0|0|1|0|0|0|0|0|0|1|1|0|0|0|0|0|1|2|0|0|0|0|0|0|0|0|8|4|3|0|0|0|H|5|S|E|4|0|0|0|0|0|1|5|0|0^^$0|@$1|2|3|4|5|6|7|2D|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|2E|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|2F|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|2G|8|@]|9|@]|A|$]]|$1|K|3|L|5|M|7|2H|8|@]|9|@$N|2I|O|2J|1|2K]]|A|$]]|$1|P|3|J|5|6|7|2L|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|2M|8|@]|9|@]|A|$]]|$1|S|3|J|5|6|7|2N|8|@]|9|@]|A|$]]|$1|T|3|L|5|M|7|2O|8|@]|9|@$N|2P|O|2Q|1|2R]]|A|$]]|$1|U|3|J|5|6|7|2S|8|@]|9|@]|A|$]]|$1|V|3|W|5|6|7|2T|8|@]|9|@]|A|$]]|$1|X|3|J|5|6|7|2U|8|@]|9|@]|A|$]]|$1|Y|3|L|5|M|7|2V|8|@]|9|@$N|2W|O|2X|1|2Y]]|A|$]]|$1|Z|3|J|5|6|7|2Z|8|@]|9|@]|A|$]]|$1|10|3|11|5|6|7|30|8|@]|9|@]|A|$]]|$1|12|3|13|5|F|7|31|8|@]|9|@]|A|$G|H]]|$1|14|3|-4|5|6|7|32|8|@]|9|@]|A|$]]|$1|15|3|16|5|6|7|33|8|@]|9|@]|A|$]]|$1|17|3|18|5|6|7|34|8|@]|9|@]|A|$]]|$1|19|3|1A|5|F|7|35|8|@]|9|@]|A|$G|H]]|$1|1B|3|1C|5|6|7|36|8|@]|9|@$N|37|O|38|1|39]]|A|$]]|$1|1D|3|-4|5|6|7|3A|8|@]|9|@]|A|$]]|$1|1E|3|1F|5|6|7|3B|8|@]|9|@]|A|$]]|$1|1G|3|1H|5|6|7|3C|8|@$N|3D|O|3E|1I|1J]]|9|@$N|3F|O|3G|1|3H]]|A|$]]|$1|1K|3|1L|5|F|7|3I|8|@]|9|@]|A|$G|H]]|$1|1M|3|1N|5|6|7|3J|8|@]|9|@]|A|$]]|$1|1O|3|J|5|6|7|3K|8|@]|9|@]|A|$]]|$1|1P|3|L|5|M|7|3L|8|@]|9|@$N|3M|O|3N|1|3O]]|A|$]]|$1|1Q|3|J|5|6|7|3P|8|@]|9|@]|A|$]]|$1|1R|3|-4|5|6|7|3Q|8|@]|9|@]|A|$]]]|1S|$1T|$5|1U|1V|1W|A|$1X|1Y|1Z|-4]]|20|$5|1U|1V|1W|A|$1X|21|1Z|-4]]|22|$5|1U|1V|1W|A|$1X|23|1Z|-4]]|24|$5|25|1V|26|A|$27|28]]|29|$5|25|1V|26|A|$27|2A]]|2B|$5|1U|1V|1W|A|$1X|2C|1Z|-4]]]]

<h2>CSS Selector method:</h2>

<p>The exact CSS selector for the element is:</p>

<pre><code>#infoBox &gt; div.col-xs-12.thumbnail.thumbnail-more &gt; div:nth-child(3) &gt; h3
</code></pre>

<p><a href="https://i.stack.imgur.com/mXqzx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mXqzx.png" alt="CSS query"></a></p>

<p>Which you could simplify to:</p>

<p><a href="https://i.stack.imgur.com/4cM5U.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4cM5U.png" alt="CSS query 2"></a></p>

<p>or even</p>

<h2><a href="https://i.stack.imgur.com/DAEZQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DAEZQ.png" alt="CSS query 3"></a></h2>

<p>Which once you have obtained the HTML document can be accessed with any of the following selectors:  </p>

<pre><code>.querySelector("#infoBox &gt; div.col-xs-12.thumbnail.thumbnail-more &gt; div:nth-child(3) &gt; h3").InnerText
.querySelector("#infoBox *&gt; div:nth-child(3) &gt; h3").InnerText
.querySelector(".valueText").InnerText
</code></pre>

<hr>

<p>Here is an example of how you would extract the current price ($10) using Internet Explorer and one of the CSS selectors shown above:</p>

<p>Code:</p>

<pre><code>Option Explicit

Public Sub GetInfo()
    Dim IE As Object
    Dim html As Object

    With CreateObject("InternetExplorer.Application")
        .Visible = True
        .navigate "https://stashpedia.com/funko/pop-vinyl/thundercats/tygra-exclusive-573"

        While .Busy Or .readyState &lt; 4: DoEvents: Wend

        Set html = .document

        With html
           Debug.Print .querySelector("#infoBox *&gt; div:nth-child(3) &gt; h3").innerText
        End With

        Stop
        'Quit '&lt;== Remember to quit application
    End With
End Sub
</code></pre>

<p>Info on CSS selectors <a href="https://developer.mozilla.org/en-US/docs/Web/CSS/CSS_Selectors" rel="nofollow noreferrer">here</a>.</p>

<hr>

<h2>XPath method:</h2>

<p>If you want to use <code>XPath</code>, which isn't supported via the method shown above, you could use <a href="http://florentbr.github.io/SeleniumBasic/" rel="nofollow noreferrer">Selenium basic</a> and your script might be like:</p>

<pre><code>Option Explicit
Public Sub GetInfoSel()
    Dim d As WebDriver
    Set d = New ChromeDriver
    Const URL = "https://stashpedia.com/funko/pop-vinyl/thundercats/tygra-exclusive-573"

    With d
        .Start "Chrome"
        .Get URL
       Debug.Print .FindElementByXPath("//*[@id=""infoBox""]/div[1]/div[3]/h3").Text
        'Quit
    End With
End Sub
</code></pre>

<p>Note: After downloading and installing, you will need to go to tools > references in VBE and add a reference to Selenium Type library</p>

<p><a href="https://i.stack.imgur.com/Mixbe.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Mixbe.png" alt="Selenium reference"></a></p>


<p>I want to find a specific value with xpath and write it in my excel table.</p>

<p><a href="https://i.stack.imgur.com/9j7xT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9j7xT.png" alt="enter image description here"></a></p>

<p>the value should be written to my excel table.</p>

<p>//edit: H3 class is the only H3 class on this site</p>

<pre><code> &lt;div class="col-md-6 col-xs-12" id="infoBox"&gt;
&lt;div class="col-xs-12 thumbnail thumbnail-more"&gt;
&lt;div class="text-center hidden-sm hidden-xs" style="margin-top:-22px"&gt;
&lt;H1 itemprop="name" class="titleDesktop toUpperCase"&gt;Tygra&lt;/H1&gt;
&lt;H2 class="productTypeText"&gt;Product Type: Funko Pop! Vinyl&lt;/H2&gt;
&lt;/div&gt;
&lt;div class="clear"&gt;&lt;/div&gt;
&lt;div class="col-xs-6 text-center"&gt;
&lt;div class="progress-bar progress-bar-success" role="progressbar"&gt;&lt;/div&gt;
&lt;H5&gt;&lt;i data-toggle="tooltip" class="fa fa-question-circle-o" data-html="true" title="Value is updated daily from recent eBay sales. See &lt;a style='color:white' href='faqcalc'&gt;FAQ&lt;/a&gt; for more info. Last update: 6 June 2018"&gt;&lt;/i&gt; Trending at:&lt;/H5&gt;
&lt;H3 class="valueText"&gt;$10&lt;/H3&gt;
&lt;/div&gt;
&lt;div class="col-xs-6 text-center"&gt;
&lt;div class="progress-bar progress-bar-info" role="progressbar"&gt;&lt;/div&gt;
&lt;H5&gt;#573&lt;/H5&gt;
&lt;H5&gt;Release: Dec 2017&lt;/H5&gt;
&lt;/div&gt;
&lt;div class="clear"&gt;&lt;br&gt;&lt;/div&gt;
&lt;div class="col-xs-6 text-center"&gt;
&lt;div class="progress-bar progress-bar-warning" role="progressbar"&gt;&lt;/div&gt;
&lt;h5&gt;See more:&lt;/h5&gt;
&lt;div class="col-xs-12 no-gutter opacityHover"&gt;
&lt;a href="/funko/all/thundercats"&gt;&lt;div class="col-md-8 col-md-offset-2 col-xs-12 no-gutter" itemprop="category"&gt;&lt;img class="img-responsive img-rounded img-center" src="/img/category/thundercats.png" alt="See more in Thundercats"&gt;&lt;div class="no-gutter"&gt;Thundercats&lt;/div&gt;&lt;/div&gt;&lt;/a&gt;
&lt;/div&gt;
</code></pre>


XPATH - Find element where child items has a specific value

我想用xpath找到一个特定值，并把它写到我的excel表中。​​该值应写入我的excel表中。//编辑: H3类是此站点上唯一的H3类 <div class="col-md-6 col-xs-12" id="infoBox"><div class="col-xs-12 thumbnail thumbnail-more...

问XPATH -查找子项具有特定值的元素
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问XPATH -查找子项具有特定值的元素EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问XPATH -查找子项具有特定值的元素
EN