如何在html中查找包含特定文本的标记名称 [英] How to find a tag name in html which contains a specific text
问题描述
您好,
请提供代码以查找包含特定文字的html标记名称或类名称或ID。
例如,
我想找到一个包含文字"copyright"的标签名称。来自打击网站地址
https://www.mrexcel.com/forum/excel-questions/731796-extract-text-into-excel-web-page-html-source- code-2.html?s = 3f64ac775f8ee0c0004edc866e3b5934
谢谢,
pazhani
您好
因此您可以尝试引用该链接并尝试开发自己的代码以满足您的要求。
免责声明:此回复包含对第三方万维网站点的引用。 Microsoft提供此信息是为了方便您。 Microsoft不控制这些网站,也未测试在这些网站上找到的任何软件或信息;因此,Microsoft不能就其中发现的任何软件或信息的质量,安全性或适用性做出任何陈述。使用互联网上的任何软件都存在固有的危险,并且Microsoft提醒您在从互联网上检索任何软件之前确保您完全了解风险的
。
问候
问候
迪帕克
Hi,
Kindly give the code for find the html tag name or class name or ID which contains a specific text.
For example,
i want to find a tag name that contains a text "copyright" from blow given website address
https://www.mrexcel.com/forum/excel-questions/731796-extract-text-into-excel-web-page-html-source-code-2.html?s=3f64ac775f8ee0c0004edc866e3b5934
thanks,
pazhani
from the description of the thread, I can see that you are working with Website.
so here , you need to set reference to Microsoft Internet Controls and
Microsoft HTML Object Library
.then you can use code like below to access the information from Web Page.
Option Explicit Sub Test() Dim ie As New InternetExplorer Dim doc As New HTMLDocument With ie .Visible = True .Navigate "https://www.federalreserve.gov/releases/h3/current/" 'can place code to wait for IE to load here .. I skipped it since its not in direct focus of question Set doc = .Document Dim t As HTMLTable Dim r As HTMLTableRow Dim c As HTMLTableCol Set t = doc.getElementById("t1tg1") 'loop through each row For Each r In t.Rows If r.Cells(0).innerText = "Mar. 2016" Then Debug.Print r.Cells(1).innerText 'loop through each column in the row 'For Each c In r.Cells ' Debug.Print c.innerText 'Next Next End With End SubReference:
Retreiving tag from table on website using VBA and put into excel
Trying to extract ONE value from a webpage with VBA in Excel
Get content of class tag in webpage using VBA
Common VBA Methods & Properties used in web automation
so you can try to refer the link and try to develop your own code to fulfil your requirement.
Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.
Regards
Regards
Deepak
这篇关于如何在html中查找包含特定文本的标记名称的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!