在 excel vba 中查看和访问 DOM 资源管理器代码-解网

问：

我正在尝试从Internet Explorer中的网站中抽象出HTML代码，并通过excel VBA在excel中使用它。源代码中显示的代码与我在 DOM 资源管理器中查看的代码不同。

正如你们中的一些人所说，很难用代码图像来理解，也许我在下面发布了抽象的 HTML 代码。由于堆栈溢出中的字符限制，我无法发布所有 HTML 代码，对不起。

这是我得到的代码（与源代码中显示的代码相同）IE.document.body.innerHTML

<tbody class="resizeTable__body"></tbody>

但我想要的是下面的代码。（与 Dom Explorer 中显示的相同）



<tbody class="resizeTable__body"><tr class="resizeTable__row resizeTable__group"><th class="resizeTable__col resizeTable__col--th resizeTable__group__col" colspan="4">2020</th></tr><tr class="resizeTable__row resizeTable__title resizeTable__title--generation resizeTable-show--xs"><td class="resizeTable__col resizeTable__title__col" colspan="4">
                <span class="d-inline-block">Payment:</span>
                <span class="d-inline-block">Direct Debit</span>
                <!-- span class="d-inline-block">Direct Debit</span -->
            </td></tr><tr class="resizeTable__row">
            <td class="resizeTable__col align-middle resizeTable-data--xs">15 Aug</td>
            <td class="resizeTable__col align-middle resizeTable-hide--xs resizeTable-data--xs">
                <span class="d-inline-block">Payment:</span>
                <span class="d-inline-block">Direct Debit</span>
                <!-- span class="d-inline-block">Direct Debit</span -->
            </td>
            <td class="resizeTable__col align-middle resizeTable-data--xs">$482.00</td>
            <td class="resizeTable__col align-middle text-right resizeTable-data--xs">
            
            </td>
            </tr><tr class="resizeTable__row resizeTable__title resizeTable__title--generation resizeTable-show--xs"><td class="resizeTable__col resizeTable__title__col" colspan="4">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">03 Jun - 02 Jul</span -->
            </td></tr><tr class="resizeTable__row">
            <td class="resizeTable__col align-middle resizeTable-data--xs">30 Jul</td>
            <td class="resizeTable__col align-middle resizeTable-hide--xs resizeTable-data--xs">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">03 Jun - 02 Jul</span -->
            </td>
            <td class="resizeTable__col align-middle resizeTable-data--xs">$482.00</td>
            <td class="resizeTable__col align-middle text-right resizeTable-data--xs">
            <a class="font-l d-print-none view--20200730000000" href="/Service/ServiceGetBillingPdfFile.ashx?caNo=68843035104&amp;Filename=18754820149.pdf&amp;bfIndicator=&amp;tranDate=20200730000000">View</a>
            </td>
            </tr><tr class="resizeTable__row resizeTable__title resizeTable__title--generation resizeTable-show--xs"><td class="resizeTable__col resizeTable__title__col" colspan="4">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">06 May - 02 Jun</span -->
            </td></tr><tr class="resizeTable__row">
            <td class="resizeTable__col align-middle resizeTable-data--xs">29 Jun</td>
            <td class="resizeTable__col align-middle resizeTable-hide--xs resizeTable-data--xs">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">06 May - 02 Jun</span -->
            </td>
            <td class="resizeTable__col align-middle resizeTable-data--xs">$835.00</td>
            <td class="resizeTable__col align-middle text-right resizeTable-data--xs">
            <a class="font-l d-print-none view--20200629000000" href="/Service/ServiceGetBillingPdfFile.ashx?caNo=68843035104&amp;Filename=19868460227.pdf&amp;bfIndicator=&amp;tranDate=20200629000000">View</a>
            </td>
            </tr><tr class="resizeTable__row resizeTable__title resizeTable__title--generation resizeTable-show--xs"><td class="resizeTable__col resizeTable__title__col" colspan="4">
                <span class="d-inline-block">Payment:</span>
                <span class="d-inline-block">Direct Debit</span>
                <!-- span class="d-inline-block">Direct Debit</span -->
            </td></tr><tr class="resizeTable__row">
            <td class="resizeTable__col align-middle resizeTable-data--xs">15 Jun</td>
            <td class="resizeTable__col align-middle resizeTable-hide--xs resizeTable-data--xs">
                <span class="d-inline-block">Payment:</span>
                <span class="d-inline-block">Direct Debit</span>
                <!-- span class="d-inline-block">Direct Debit</span -->
            </td>
            <td class="resizeTable__col align-middle resizeTable-data--xs">$165.00</td>
            <td class="resizeTable__col align-middle text-right resizeTable-data--xs">
            
            </td>
            </tr><tr class="resizeTable__row resizeTable__title resizeTable__title--generation resizeTable-show--xs"><td class="resizeTable__col resizeTable__title__col" colspan="4">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">02 Apr - 05 May</span -->
            </td></tr><tr class="resizeTable__row">
            <td class="resizeTable__col align-middle resizeTable-data--xs">28 May</td>
            <td class="resizeTable__col align-middle resizeTable-hide--xs resizeTable-data--xs">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">02 Apr - 05 May</span -->
            </td>
            <td class="resizeTable__col align-middle resizeTable-data--xs">$165.00</td>
            <td class="resizeTable__col align-middle text-right resizeTable-data--xs">
            <a class="font-l d-print-none view--20200528000000" href="/Service/ServiceGetBillingPdfFile.ashx?caNo=68843035104&amp;Filename=10169653696.pdf&amp;bfIndicator=&amp;tranDate=20200528000000">View</a>
            </td>
            </tr><tr class="resizeTable__row resizeTable__title resizeTable__title--generation resizeTable-show--xs"><td class="resizeTable__col resizeTable__title__col" colspan="4">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">04 Feb - 03 Mar</span -->
            </td></tr><tr class="resizeTable__row">
            <td class="resizeTable__col align-middle resizeTable-data--xs">30 Mar</td>
            <td class="resizeTable__col align-middle resizeTable-hide--xs resizeTable-data--xs">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">04 Feb - 03 Mar</span -->
            </td>
            <td class="resizeTable__col align-middle resizeTable-data--xs">$543.00</td>
            <td class="resizeTable__col align-middle text-right resizeTable-data--xs">
            <a class="font-l d-print-none view--20200330000000" href="/Service/ServiceGetBillingPdfFile.ashx?caNo=68843035104&amp;Filename=19948328251.pdf&amp;bfIndicator=&amp;tranDate=20200330000000">View</a>
            </td>
            </tr><tr class="resizeTable__row resizeTable__title resizeTable__title--generation resizeTable-show--xs"><td class="resizeTable__col resizeTable__title__col" colspan="4">
                <span class="d-inline-block">Payment:</span>
                <span class="d-inline-block">Direct Debit</span>
                <!-- span class="d-inline-block">Direct Debit</span -->
            </td></tr><tr class="resizeTable__row">
            <td class="resizeTable__col align-middle resizeTable-data--xs">16 Mar</td>
            <td class="resizeTable__col align-middle resizeTable-hide--xs resizeTable-data--xs">
                <span class="d-inline-block">Payment:</span>
                <span class="d-inline-block">Direct Debit</span>
                <!-- span class="d-inline-block">Direct Debit</span -->
            </td>
            <td class="resizeTable__col align-middle resizeTable-data--xs">$485.00</td>
            <td class="resizeTable__col align-middle text-right resizeTable-data--xs">
            
            </td>
            </tr><tr class="resizeTable__row resizeTable__title resizeTable__title--generation resizeTable-show--xs"><td class="resizeTable__col resizeTable__title__col" colspan="4">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">01 Jan - 03 Feb</span -->
            </td></tr><tr class="resizeTable__row">
            <td class="resizeTable__col align-middle resizeTable-data--xs">27 Feb</td>
            <td class="resizeTable__col align-middle resizeTable-hide--xs resizeTable-data--xs">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">01 Jan - 03 Feb</span -->
            </td>
            <td class="resizeTable__col align-middle resizeTable-data--xs">$485.00</td>
            <td class="resizeTable__col align-middle text-right resizeTable-data--xs">
            <a class="font-l d-print-none view--20200227000000" href="/Service/ServiceGetBillingPdfFile.ashx?caNo=68843035104&amp;Filename=18754703653.pdf&amp;bfIndicator=&amp;tranDate=20200227000000">View</a>
            </td>
            </tr><tr class="resizeTable__row resizeTable__title resizeTable__title--generation resizeTable-show--xs"><td class="resizeTable__col resizeTable__title__col" colspan="4">
                <span class="d-inline-block">Payment:</span>
                <span class="d-inline-block">Direct Debit</span>
                <!-- span class="d-inline-block">Direct Debit</span -->
            </td></tr><tr class="resizeTable__row">
            <td class="resizeTable__col align-middle resizeTable-data--xs">15 Feb</td>
            <td class="resizeTable__col align-middle resizeTable-hide--xs resizeTable-data--xs">
                <span class="d-inline-block">Payment:</span>
                <span class="d-inline-block">Direct Debit</span>
                <!-- span class="d-inline-block">Direct Debit</span -->
            </td>
            <td class="resizeTable__col align-middle resizeTable-data--xs">$395.00</td>
            <td class="resizeTable__col align-middle text-right resizeTable-data--xs">
            
            </td>
            </tr><tr class="resizeTable__row resizeTable__title resizeTable__title--generation resizeTable-show--xs"><td class="resizeTable__col resizeTable__title__col" colspan="4">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">30 Nov - 31 Dec</span -->
            </td></tr><tr class="resizeTable__row">
            <td class="resizeTable__col align-middle resizeTable-data--xs">30 Jan</td>
            <td class="resizeTable__col align-middle resizeTable-hide--xs resizeTable-data--xs">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">30 Nov - 31 Dec</span -->
            </td>
            <td class="resizeTable__col align-middle resizeTable-data--xs">$395.00</td>
            <td class="resizeTable__col align-middle text-right resizeTable-data--xs">
            <a class="font-l d-print-none view--20200130000000" href="/Service/ServiceGetBillingPdfFile.ashx?caNo=68843035104&amp;Filename=12816959762.pdf&amp;bfIndicator=&amp;tranDate=20200130000000">View</a>
            </td>
            </tr><tr class="resizeTable__row resizeTable__title resizeTable__title--generation resizeTable-show--xs"><td class="resizeTable__col resizeTable__title__col" colspan="4">
                <span class="d-inline-block">Payment:</span>
                <span class="d-inline-block">Direct Debit</span>
                <!-- span class="d-inline-block">Direct Debit</span -->
            </td></tr><tr class="resizeTable__row">
            <td class="resizeTable__col align-middle resizeTable-data--xs">15 Jan</td>
            <td class="resizeTable__col align-middle resizeTable-hide--xs resizeTable-data--xs">
                <span class="d-inline-block">Payment:</span>
                <span class="d-inline-block">Direct Debit</span>
                <!-- span class="d-inline-block">Direct Debit</span -->
            </td>
            <td class="resizeTable__col align-middle resizeTable-data--xs">$511.00</td>
            <td class="resizeTable__col align-middle text-right resizeTable-data--xs">
            
            </td>
            </tr><tr class="resizeTable__row resizeTable__group"><th class="resizeTable__col resizeTable__col--th resizeTable__group__col" colspan="4">2019</th></tr><tr class="resizeTable__row resizeTable__title resizeTable__title--generation resizeTable-show--xs"><td class="resizeTable__col resizeTable__title__col" colspan="4">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">02 Nov - 29 Nov</span -->
            </td></tr><tr class="resizeTable__row">
            <td class="resizeTable__col align-middle resizeTable-data--xs">30 Dec</td>
            <td class="resizeTable__col align-middle resizeTable-hide--xs resizeTable-data--xs">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">02 Nov - 29 Nov</span -->
            </td>
            <td class="resizeTable__col align-middle resizeTable-data--xs">$511.00</td>
            <td class="resizeTable__col align-middle text-right resizeTable-data--xs">
            <a class="font-l d-print-none view--20191230000000" href="/Service/ServiceGetBillingPdfFile.ashx?caNo=68843035104&amp;Filename=13441911409.pdf&amp;bfIndicator=&amp;tranDate=20191230000000">View</a>
            </td>
            </tr><tr class="resizeTable__row resizeTable__title resizeTable__title--generation resizeTable-show--xs"><td class="resizeTable__col resizeTable__title__col" colspan="4">
                <span class="d-inline-block">Payment:</span>
                <span class="d-inline-block">Direct Debit</span>
                <!-- span class="d-inline-block">Direct Debit</span -->
            </td></tr><tr class="resizeTable__row">
            <td class="resizeTable__col align-middle resizeTable-data--xs">16 Dec</td>
            <td class="resizeTable__col align-middle resizeTable-hide--xs resizeTable-data--xs">
                <span class="d-inline-block">Payment:</span>
                <span class="d-inline-block">Direct Debit</span>
                <!-- span class="d-inline-block">Direct Debit</span -->
            </td>
            <td class="resizeTable__col align-middle resizeTable-data--xs">$896.00</td>
            <td class="resizeTable__col align-middle text-right resizeTable-data--xs">
            
            </td>
            </tr><tr class="resizeTable__row resizeTable__title resizeTable__title--generation resizeTable-show--xs"><td class="resizeTable__col resizeTable__title__col" colspan="4">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">01 Oct - 01 Nov</span -->
            </td></tr><tr class="resizeTable__row">
            <td class="resizeTable__col align-middle resizeTable-data--xs">28 Nov</td>
            <td class="resizeTable__col align-middle resizeTable-hide--xs resizeTable-data--xs">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">01 Oct - 01 Nov</span -->
            </td>
            <td class="resizeTable__col align-middle resizeTable-data--xs">$896.00</td>
            <td class="resizeTable__col align-middle text-right resizeTable-data--xs">
            <a class="font-l d-print-none view--20191128000000" href="/Service/ServiceGetBillingPdfFile.ashx?caNo=68843035104&amp;Filename=16879666474.pdf&amp;bfIndicator=&amp;tranDate=20191128000000">View</a>
            </td>
            </tr><tr class="resizeTable__row resizeTable__title resizeTable__title--generation resizeTable-show--xs"><td class="resizeTable__col resizeTable__title__col" colspan="4">
                <span class="d-inline-block">Payment:</span>
                <span class="d-inline-block">Direct Debit</span>
                <!-- span class="d-inline-block">Direct Debit</span -->
            </td></tr><tr class="resizeTable__row">
            <td class="resizeTable__col align-middle resizeTable-data--xs">15 Nov</td>
            <td class="resizeTable__col align-middle resizeTable-hide--xs resizeTable-data--xs">
                <span class="d-inline-block">Payment:</span>
                <span class="d-inline-block">Direct Debit</span>
                <!-- span class="d-inline-block">Direct Debit</span -->
            </td>
            <td class="resizeTable__col align-middle resizeTable-data--xs">$1,243.00</td>
            <td class="resizeTable__col align-middle text-right resizeTable-data--xs">
            
            </td>
            </tr><tr class="resizeTable__row resizeTable__title resizeTable__title--generation resizeTable-show--xs"><td class="resizeTable__col resizeTable__title__col" colspan="4">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">01 Sep - 30 Sep</span -->
            </td></tr><tr class="resizeTable__row">
            <td class="resizeTable__col align-middle resizeTable-data--xs">30 Oct</td>
            <td class="resizeTable__col align-middle resizeTable-hide--xs resizeTable-data--xs">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">01 Sep - 30 Sep</span -->
            </td>
            <td class="resizeTable__col align-middle resizeTable-data--xs">$1,243.00</td>
            <td class="resizeTable__col align-middle text-right resizeTable-data--xs">
            <a class="font-l d-print-none view--20191030000000" href="/Service/ServiceGetBillingPdfFile.ashx?caNo=68843035104&amp;Filename=18284515211.pdf&amp;bfIndicator=&amp;tranDate=20191030000000">View</a>
            </td>
            </tr><tr class="resizeTable__row resizeTable__title resizeTable__title--generation resizeTable-show--xs"><td class="resizeTable__col resizeTable__title__col" colspan="4">
                <span class="d-inline-block">Payment:</span>
                <span class="d-inline-block">Direct Debit</span>
                <!-- span class="d-inline-block">Direct Debit</span -->
            </td></tr><tr class="resizeTable__row">
            <td class="resizeTable__col align-middle resizeTable-data--xs">15 Oct</td>
            <td class="resizeTable__col align-middle resizeTable-hide--xs resizeTable-data--xs">
                <span class="d-inline-block">Payment:</span>
                <span class="d-inline-block">Direct Debit</span>
                <!-- span class="d-inline-block">Direct Debit</span -->
            </td>
            <td class="resizeTable__col align-middle resizeTable-data--xs">$1,301.00</td>
            <td class="resizeTable__col align-middle text-right resizeTable-data--xs">
            
            </td>
            </tr><tr class="resizeTable__row resizeTable__title resizeTable__title--generation resizeTable-show--xs"><td class="resizeTable__col resizeTable__title__col" colspan="4">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">01 Aug - 31 Aug</span -->
            </td></tr><tr class="resizeTable__row">
            <td class="resizeTable__col align-middle resizeTable-data--xs">28 Sep</td>
            <td class="resizeTable__col align-middle resizeTable-hide--xs resizeTable-data--xs">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">01 Aug - 31 Aug</span -->
            </td>
            <td class="resizeTable__col align-middle resizeTable-data--xs">$1,301.00</td>
            <td class="resizeTable__col align-middle text-right resizeTable-data--xs">
            <a class="font-l d-print-none view--20190928000000" href="/Service/ServiceGetBillingPdfFile.ashx?caNo=68843035104&amp;Filename=14379668674.pdf&amp;bfIndicator=&amp;tranDate=20190928000000">View</a>
            </td>
            </tr><tr class="resizeTable__row resizeTable__title resizeTable__title--generation resizeTable-show--xs"><td class="resizeTable__col resizeTable__title__col" colspan="4">
                <span class="d-inline-block">Payment:</span>
                <span class="d-inline-block">Direct Debit</span>
                <!-- span class="d-inline-block">Direct Debit</span -->
            </td></tr><tr class="resizeTable__row">
            <td class="resizeTable__col align-middle resizeTable-data--xs">16 Sep</td>
            <td class="resizeTable__col align-middle resizeTable-hide--xs resizeTable-data--xs">
                <span class="d-inline-block">Payment:</span>
                <span class="d-inline-block">Direct Debit</span>
                <!-- span class="d-inline-block">Direct Debit</span -->
            </td>
            <td class="resizeTable__col align-middle resizeTable-data--xs">$1,459.00</td>
            <td class="resizeTable__col align-middle text-right resizeTable-data--xs">
            
            </td>
            </tr><tr class="resizeTable__row resizeTable__title resizeTable__title--generation resizeTable-show--xs"><td class="resizeTable__col resizeTable__title__col" colspan="4">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">03 Jul - 31 Jul</span -->
            </td></tr><tr class="resizeTable__row">
            <td class="resizeTable__col align-middle resizeTable-data--xs">29 Aug</td>
            <td class="resizeTable__col align-middle resizeTable-hide--xs resizeTable-data--xs">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">03 Jul - 31 Jul</span -->
            </td>
            <td class="resizeTable__col align-middle resizeTable-data--xs">$1,459.00</td>
            <td class="resizeTable__col align-middle text-right resizeTable-data--xs">
            <a class="font-l d-print-none view--20190829000000" href="/Service/ServiceGetBillingPdfFile.ashx?caNo=68843035104&amp;Filename=10629821442.pdf&amp;bfIndicator=&amp;tranDate=20190829000000">View</a>
            </td>
            </tr><tr class="resizeTable__row resizeTable__title resizeTable__title--generation resizeTable-show--xs"><td class="resizeTable__col resizeTable__title__col" colspan="4">
                <span class="d-inline-block">Payment:</span>
                <span class="d-inline-block">Direct Debit</span>
                <!-- span class="d-inline-block">Direct Debit</span -->
            </td></tr><tr class="resizeTable__row">
            <td class="resizeTable__col align-middle resizeTable-data--xs">15 Aug</td>
            <td class="resizeTable__col align-middle resizeTable-hide--xs resizeTable-data--xs">
                <span class="d-inline-block">Payment:</span>
                <span class="d-inline-block">Direct Debit</span>
                <!-- span class="d-inline-block">Direct Debit</span -->
            </td>
            <td class="resizeTable__col align-middle resizeTable-data--xs">$1,606.00</td>
            <td class="resizeTable__col align-middle text-right resizeTable-data--xs">
            
            </td>
            </tr><tr class="resizeTable__row resizeTable__title resizeTable__title--generation resizeTable-show--xs"><td class="resizeTable__col resizeTable__title__col" colspan="4">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">30 May - 02 Jul</span -->
            </td></tr><tr class="resizeTable__row">
            <td class="resizeTable__col align-middle resizeTable-data--xs">30 Jul</td>
            <td class="resizeTable__col align-middle resizeTable-hide--xs resizeTable-data--xs">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">30 May - 02 Jul</span -->
            </td>
            <td class="resizeTable__col align-middle resizeTable-data--xs">$1,606.00</td>
            <td class="resizeTable__col align-middle text-right resizeTable-data--xs">
            <a class="font-l d-print-none view--20190730000000" href="/Service/ServiceGetBillingPdfFile.ashx?caNo=68843035104&amp;Filename=10209446397.pdf&amp;bfIndicator=&amp;tranDate=20190730000000">View</a>
            </td>
            </tr><tr class="resizeTable__row resizeTable__title resizeTable__title--generation resizeTable-show--xs"><td class="resizeTable__col resizeTable__title__col" colspan="4">
                <span class="d-inline-block">Payment:</span>
                <span class="d-inline-block">Direct Debit</span>
                <!-- span class="d-inline-block">Direct Debit</span -->
            </td></tr><tr class="resizeTable__row">
            <td class="resizeTable__col align-middle resizeTable-data--xs">15 Jul</td>
            <td class="resizeTable__col align-middle resizeTable-hide--xs resizeTable-data--xs">
                <span class="d-inline-block">Payment:</span>
                <span class="d-inline-block">Direct Debit</span>
                <!-- span class="d-inline-block">Direct Debit</span -->
            </td>
            <td class="resizeTable__col align-middle resizeTable-data--xs">$1,055.00</td>
            <td class="resizeTable__col align-middle text-right resizeTable-data--xs">
            
            </td>
            </tr><tr class="resizeTable__row resizeTable__title resizeTable__title--generation resizeTable-show--xs"><td class="resizeTable__col resizeTable__title__col" colspan="4">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">03 May - 29 May</span -->
            </td></tr><tr class="resizeTable__row">
            <td class="resizeTable__col align-middle resizeTable-data--xs">27 Jun</td>
            <td class="resizeTable__col align-middle resizeTable-hide--xs resizeTable-data--xs">
                <span class="d-inline-block">Bill</span>
                <span class="d-inline-block"></span>
                <!-- span class="d-inline-block">03 May - 29 May</span -->
            </td>
            <td class="resizeTable__col align-middle resizeTable-data--xs">$1,055.00</td>
            <td class="resizeTable__col align-middle text-right resizeTable-data--xs">
            <a class="font-l d-print-none view--20190627000000" href="/Service/ServiceGetBillingPdfFile.ashx?caNo=68843035104&amp;Filename=14066798372.pdf&amp;bfIndicator=&amp;tranDate=20190627000000">View</a>
            </td>
            </tr></tbody>

你可以看到 DOM Explorer 中还有其他代码（内容），但只能获取源代码 one。有什么方法可以在 DOM Explorer 中获取代码吗？<tbody>IE.document.body.innerHTML

JavaScript HTML Excel Internet-Explorer DOM

2赞 8/25/2020

请发布代码，而不是代码的图像。

0赞 Deepak-MSFT 8/25/2020

IE.document.body.innerHTML 应返回源代码。我想和你确认你通过运行这段代码到底得到了什么结果？您显示的是表正文标签。这些数据是动态生成的吗？如果可能，请提供任何示例 HTML 代码来测试问题。如果网站是公开的，那么您也可以尝试共享网站地址。它可以帮助我们测试问题。

0赞 Eugene 8/26/2020

由于源代码或 DOM Explorer 的 body 标签中大约有 400 行代码，并且网站只有在登录后才能访问，因此很难在此处显示，因此很抱歉。

0赞 Eugene 8/26/2020

但是我在其他网络上发现了任何类似的情况，也许我可以在这里分享。

0赞 Eugene 8/26/2020

@Deepak-MSFT，回答你的问题，这些数据是动态生成的，这样，我还能得到吗？

答：

0赞 Deepak-MSFT 8/28/2020 #1

我尝试创建一个可以动态生成表中数据的网页。然后，我尝试使用VBA IE Automation获取该数据。

示例VBA代码：

Sub demo()

    Dim URL As String
    Dim IE As Object
    Dim hTable, hBody, hTR, hTD, ws As Object
    Dim ii, y, z As Integer
    Set IE = CreateObject("InternetExplorer.Application")
    Set ws = Sheets("Sheet1")
   
    IE.Visible = True
 
  
    URL = "----your URL here---------"
 
    IE.navigate URL
 
    
    Do While IE.readyState = 4: DoEvents: Loop
    Do Until IE.readyState = 4: DoEvents: Loop
 
     Set hTable = IE.document.getElementById("myTableData")
    ii = 1
    z = 1
        
            Set hBody = hTable.getElementsByTagName("tbody")
            For Each bb In hBody
                Set hTR = bb.getElementsByTagName("tr")
                For Each Tr In hTR
                    Set hTD = Tr.getElementsByTagName("td")
                    y = 1
                    For Each Td In hTD
                        ws.Cells(z, y).Value = Td.innerText
                        y = y + 1
                    Next Td
                    DoEvents
                    z = z + 1
                Next Tr
                Exit For
            Next bb
                     
    Set IE = Nothing
    
End Sub

输出：

这只是一个示例代码。此外，您可以尝试根据自己的要求修改此示例，并尝试获取所需的数据。

上一个：窗口对象的焦点方法在 IE 中不起作用（2020）

下一个：InternetExplorer html 属性更改

在 excel vba 中查看和访问 DOM 资源管理器代码

View and access DOM Explorer code in excel vba

评论