试图提取数据

Question

我正在使用VBA并从页面中提取数据。我用“oIE.document.body.innerHTML”提取了很多数据

但是，我遇到了一些在这个innerHTML中看不到页面上的数据的情况。我在检查页面上的确切地点时发现了它。在屏幕下面。可以用VBA提取这类数据吗？我对标有蓝色的数据感兴趣，确切地说是这个号码。

屏幕截图

​

​

好的。

我从我的公司页面中提取数据

                link = "Page" 
                
                oIE.navigate link
                Do Until Not oIE.Busy And oIE.readyState = READYSTATE_COMPLETE: Loop
                HTMLsource = UCase(oIE.document.body.innerHTML)

然后我用拆分函数来得到我需要的数据。然而，在我的最新项目中，我遇到了一些数据，这些数据在现场是可见的，但不是在这个字符串中，而是用innerHTML方法获得的。在innerHTML方法之后得到的字符串：

但是，当我用Mozzila中的"inspect元素“检查页面时，我发现上面的字符串丢失了我需要的数据。但它在检查元素中是可见的。

<table xmlns="http://www.w3.org/1999/xhtml" id="treeBodyTable" data-drag="Name" width="239"><tbody><tr class="mx_hidden-row"><td position="-1" width="1"></td><td id="ROW_1" width="238"></td></tr><tr id="0,0" o="20336.41905.55555.59004" r="" class="root-node 
                    even
                " style="height: 35px;" height="35"><td class="" position="-1"></td><td position="1" rownumber="1" rmbid="20336.41905.55555.59004" rmbrow="0,0" draggable="true"><div id="0,0" o="20336.41905.55555.59004" r="" t="" draggable="false"><table draggable="false"><tbody draggable="false"><tr id="0,0" o="20336.41905.55555.59004" r="" draggable="false"><td draggable="false"><input name="emxTableRowIdActual" class="small" id="rmbrow-0,0" value="|20336.41905.55555.59004||0,0" onclick="doFreezePaneCheckboxClick(this, event); doCheckSelectAll();" draggable="false" type="checkbox"></td><td id="icon_0,0" draggable="false"><a href="javascript:;" draggable="false"><img src="images/iconSmallPart.png" draggable="false"></a>
                                    &nbsp;
                                </td><td title="80275509" position="1" rmbid="20336.41905.55555.59004" rmbrow="0,0" draggable="false" valign="middle"><a href="javascript:link(&quot;1&quot;,&quot;20336.41905.55555.59004&quot;,&quot;&quot;,&quot;&quot;,&quot;80275509&quot;)" data-oid="20336.41905.55555.59004" data-icon="images/iconSmallPart.png" class="object" draggable="false">80275509</a></td></tr></tbody></table></div></td></tr><tr id="0,1" o="20336.41905.60930.27530" r="" class="root-node 
                    mx_altRow
                " style="height: 35px;" height="35"><td class="" position="-1"></td><td position="1" rownumber="1" rmbid="20336.41905.60930.27530" rmbrow="0,1" draggable="true"><div id="0,1" o="20336.41905.60930.27530" r="" t="" draggable="false"><table draggable="false"><tbody draggable="false"><tr id="0,1" o="20336.41905.60930.27530" r="" draggable="false"><td draggable="false"><input name="emxTableRowIdActual" class="small" id="rmbrow-0,1" value="|20336.41905.60930.27530||0,1" onclick="doFreezePaneCheckboxClick(this, event); doCheckSelectAll();" draggable="false" type="checkbox"></td><td id="icon_0,1" draggable="false"><a href="javascript:;" draggable="false"><img src="images/iconSmallPart.png" draggable="false"></a>
                                    &nbsp;
                                </td><td title="80275509" position="1" rmbid="20336.41905.60930.27530" rmbrow="0,1" draggable="false" valign="middle"><a href="javascript:link(&quot;1&quot;,&quot;20336.41905.60930.27530&quot;,&quot;&quot;,&quot;&quot;,&quot;80275509&quot;)" data-oid="20336.41905.60930.27530" data-icon="images/iconSmallPart.png" class="object" draggable="false">80275509</a></td></tr></tbody></table></div></td></tr><tr id="0,2" o="20336.41905.2564.37500" r="" class="root-node 
                    even
                " style="height: 33px;" height="33"><td class="" position="-1"></td><td position="1" rownumber="1" rmbid="20336.41905.2564.37500" rmbrow="0,2" draggable="true"><div id="0,2" o="20336.41905.2564.37500" r="" t="" draggable="false"><table draggable="false"><tbody draggable="false"><tr id="0,2" o="20336.41905.2564.37500" r="" draggable="false"><td draggable="false"><input name="emxTableRowIdActual" class="small" id="rmbrow-0,2" value="|20336.41905.2564.37500||0,2" onclick="doFreezePaneCheckboxClick(this, event); doCheckSelectAll();" draggable="false" type="checkbox"></td><td id="icon_0,2" draggable="false"><a href="javascript:;" draggable="false"><img src="images/fpc.gif" draggable="false"></a>
                                    &nbsp;
                                </td><td title="80275509" position="1" rmbid="20336.41905.2564.37500" rmbrow="0,2" draggable="false" valign="middle"><a href="javascript:link(&quot;1&quot;,&quot;20336.41905.2564.37500&quot;,&quot;&quot;,&quot;&quot;,&quot;80275509&quot;)" data-oid="20336.41905.2564.37500" data-icon="images/fpc.gif" class="object" draggable="false">80275509</a></td></tr></tbody></table></div></td></tr></tbody></table>

所以我的问题是:这能用VBA提取这些“隐藏”数据吗？

Answer 1

你应该能看到这个。

Set elements = doc.getElementsByid("0,0")
debug.Print = elements.innerHTML

将elements声明为object应该会给您提供以下信息(是吗？)

编辑(包括图书馆)：

​

​