请协助解决Google表格ImportXML函数的XPath问题 [英] Please Assist with XPath Problem for Google Sheets ImportXML Function

问题描述

我无法找出要在Google表格中使用的正确XPath，以提取此页面顶部的3个(三)按成本产生的收益"值:

I can't figure out the correct XPath to use in Google Sheets for extracting the 3 (three) "Yield on Cost" values at the top of this page: https://seekingalpha.com/symbol/GE/dividends/yield-on-cost

或此页面顶部的5(五)个增长"值: https://seekingalpha.com/symbol/GE/dividends/dividend-growth

Or the 5 (five) "Growth" values at the top of this page: https://seekingalpha.com/symbol/GE/dividends/dividend-growth

我已经阅读了很多有关在Google表格中同时使用IMPORTXML和IMPORTHTML的信息丰富的网页，并且过去我取得了不错的成就-但是我在这两页上都空着空白.这可能是由于我缺少其他人可能会立即看到并理解的一些基本问题.

I have read many informative webpages on the subject of using both IMPORTXML and IMPORTHTML within Google Sheets, and I have had good success in the past -- but I am coming up empty on these two pages. This is likely due to me missing some fundamental problem that others would probably see and understand immediately.

发布我尝试过的Xpath并没有多大意义，因为我确实尝试了100多种变体.

There's not much point in me posting Xpaths I have tried -- as I have literally tried over 100 variations.

我将非常感谢为我实现目标提供的任何指导.

I would be very grateful for any guidance offered to help me to achieve my goal.

推荐答案

https://seekingalpha.com/网站无法取消，因为它依赖于JavaScript，而Google表格完全不能与JavaScript一起使用.您可以看到自己是否暂时禁用JS:

https://seekingalpha.com/ site can't be scrapped because it depends on JavaScript and Google Sheets can't work with JavaScript at all. you can see yourself if you disable JS temporarily:

这篇关于请协助解决Google表格ImportXML函数的XPath问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！