如何实现iframe内数值实时采集求和并在HTML页面展示
需求说明
- 采集iframe加载的赛事页面中
1-0格式的比分内容,拆分两个数字求和后展示 - 要求数据实时同步更新,比分变更后求和结果立即刷新
- 现有页面已嵌入3个赛事iframe,每500ms刷新一次图表
注:仅掌握谷歌表格公式抓取方法,不了解前端数据抓取逻辑

实现方案
前置说明
你嵌入的赛事iframe与主页面域名不同,默认受浏览器同源策略限制无法直接读取iframe内容,本地自用测试可通过关闭浏览器安全限制实现:
给Chrome/Edge浏览器快捷方式的「目标」路径后追加参数,注意参数和原有路径之间加空格:--disable-web-security --user-data-dir="C:\Temp\ChromeDev"
启动后再打开你的本地HTML文件即可正常读取iframe内容。
完整修改后代码
<html> <head> <style> * { box-sizing: border-box; } .column { float: left; width: 360px; margin-right: 20px; } .result-area { clear: both; padding: 20px; font-size: 20px; font-weight: bold; background: #f5f5f5; margin-top: 20px; } .result-item { margin: 10px 0; } </style> <script language="JavaScript"> let intervalID window.addEventListener('DOMContentLoaded', () => { intervalID = setInterval(refreshIt, 500); // 每0.5秒刷新一次 }) function getScoreSum(iframe) { try { const doc = iframe.contentDocument || iframe.contentWindow.document; // 正则匹配x-y格式的比分 const scoreText = doc.body.innerText.match(/\d+-\d+/g)?.[0]; if (!scoreText) return 0; const [a, b] = scoreText.split('-').map(Number); return a + b; } catch (e) { return 0; } } function refreshIt() { // 原有刷新图表逻辑保留 if (document.images) { document.images['Chart 1'].src = ChartBar1.value; document.images['Chart 2'].src = ChartBar2.value; document.images['Chart 3'].src = ChartBar3.value; } // 新增比分采集求和逻辑 const sum1 = getScoreSum(document.getElementById('the-frame')); const sum2 = getScoreSum(document.getElementById('the-frame2')); const sum3 = getScoreSum(document.getElementById('the-frame3')); // 更新页面展示内容 document.getElementById('res1').innerText = `Radar 1 总进球:${sum1}`; document.getElementById('res2').innerText = `Radar 2 总进球:${sum2}`; document.getElementById('res3').innerText = `Radar 3 总进球:${sum3}`; document.getElementById('total').innerText = `三个赛事总进球合计:${sum1 + sum2 + sum3}`; } </script> </head> <body> <div class="row"> <div class="column left"> <form action="" method="post" id="url-setter"> <button type="submit" name="submit">Radar 1</button> <input type="text" name="url" id="url" style="width: 283px;" /> </form> <iframe id="the-frame" width="347" height="282" src=""></iframe> <script type="text/javascript"> (function () { "use strict"; var url_setter = document.getElementById('url-setter'), url = document.getElementById('url'), the_iframe = document.getElementById('the-frame'); url_setter.onsubmit = function (event) { event.preventDefault(); the_iframe.src = "https://sports.staticcache.org/scoreboards/scoreboards-football/index.html?eventId=" + url.value; }; }()); </script> <form method="post" target="imgChart1"> <input type="submit" value="Chart 1" /> <input type="text" id="ChartBar1" name="ChartBar1" style="width: 286px;"><br> </form> <img src="https://www.futebolnaveia.com.br/wp-content/uploads/2020/06/betfair-app.png" name="Chart 1"> </div> <div class="column middle"> <form action="" method="post" id="url-setter2"> <button type="submit" name="submit">Radar 2</button> <input type="text" name="url2" id="url2" style="width: 283px;" /> </form> <iframe id="the-frame2" width="347" height="282" src=""></iframe> <script type="text/javascript"> (function () { "use strict"; var url_setter = document.getElementById('url-setter2'), url = document.getElementById('url2'), the_iframe = document.getElementById('the-frame2'); url_setter.onsubmit = function (event) { event.preventDefault(); the_iframe.src = "https://sports.staticcache.org/scoreboards/scoreboards-football/index.html?eventId=" + url2.value; }; }()); </script> <form method="post" target="imgChart2"> <input type="submit" value="Chart 2" /> <input type="text" id="ChartBar2" name="ChartBar2" style="width: 286px;"><br> </form> <img src="https://www.futebolnaveia.com.br/wp-content/uploads/2020/06/betfair-app.png" name="Chart 2"> </div> <div class="column right"> <form action="" method="post" id="url-setter3"> <button type="submit" name="submit">Radar 3</button> <input type="text" name="url3" id="url3" style="width: 283px;" /> </form> <iframe id="the-frame3" width="347" height="282" src=""></iframe> <script type="text/javascript"> (function () { "use strict"; var url_setter = document.getElementById('url-setter3'), url = document.getElementById('url3'), the_iframe = document.getElementById('the-frame3'); url_setter.onsubmit = function (event) { event.preventDefault(); the_iframe.src = "https://sports.staticcache.org/scoreboards/scoreboards-football/index.html?eventId=" + url3.value; }; }()); </script> <form method="post" target="imgChart3"> <input type="submit" value="Chart 3" /> <input type="text" id="ChartBar3" name="ChartBar3" style="width: 286px;"><br> </form> <img src="https://www.futebolnaveia.com.br/wp-content/uploads/2020/06/betfair-app.png" name="Chart 3"> </div> </div> <!-- 新增结果展示区域 --> <div class="result-area"> <div class="result-item" id="res1">Radar 1 总进球:0</div> <div class="result-item" id="res2">Radar 2 总进球:0</div> <div class="result-item" id="res3">Radar 3 总进球:0</div> <div class="result-item" id="total" style="margin-top:15px;color:red;">三个赛事总进球合计:0</div> </div> </body> </html>
修改说明
- 修复了原有CSS的错误:补全了通配符选择器
*,给宽度属性增加了px单位 - 新增了结果展示区域的样式和DOM结构
- 新增了
getScoreSum函数,负责从指定iframe中提取比分、计算求和 - 原有定时刷新逻辑中新增求和计算和页面更新的代码,和图表刷新同频率执行,实现实时同步
内容的提问来源于stack exchange,提问作者Digital Farmer
相关产品推荐
相关产品推荐

