ExcelHome技术论坛

 找回密码
 免费注册

QQ登录

只需一步,快速开始

快捷登录

搜索
EH技术汇-专业的职场技能充电站 妙哉!函数段子手趣味讲函数 Excel服务器-会Excel,做管理系统 效率神器,一键搞定繁琐工作
HR薪酬管理数字化实战 Excel 2021函数公式学习大典 Excel数据透视表实战秘技 打造核心竞争力的职场宝典
让更多数据处理,一键完成 数据工作者的案头书 免费直播课集锦 ExcelHome出品 - VBA代码宝免费下载
用ChatGPT与VBA一键搞定Excel WPS表格从入门到精通 Excel VBA经典代码实践指南
12
返回列表 发新帖
楼主: 莫悠悠

[求助] 网上抓取数据

[复制链接]

TA的精华主题

TA的得分主题

 楼主| 发表于 2024-3-9 09:54 | 显示全部楼层
http://ddx.gubit.cn/ygetszddxpm. ... =0.6813226370393328
{"data":[["002873","10.55","10.01","0.230","0.125","11578.557","-0.435","-3.897","1.458","5.557","6","1","542.93","947.52","57.3"],["002902","25.86","10.00","5.253","5.098","10770.704","4.301","-6.345","5.240","-49.865","3","1","20896.68","32148.74","65.0"],["002613","4.09","9.95","2.465","1.514","300.068","2.265","-0.026","-1.419","-13.139","5","1","6032.25","10224.16","59.0"],["000504","8.78","10.03","0.638","0.268","270.591","0.874","1.326","1.365","6.225","4","1","1726.55","3215.18","53.7"],["002313","9.63","10.06","4.276","3.062","169.110","4.698","-2.816","0.956","-47.602","5","1","15347.91","28741.41","53.4"],["002907","14.69","10.04","1.316","1.027","156.901","1.199","0.390","0.686","-8.077","3","1","5920.94","10944.43","54.1"],["002575","6.79","10.05","1.245","0.949","134.820","1.007","1.342","-1.174","-0.400","5","1","4787.48","13225.07","36.2"],["002775","2.84","10.08","1.039","1.161","105.975","1.213","-0.195","2.594","-8.304","3","2","1284.42","5076.77","25.3"],["001208","9.24","10.00","2.194","1.660","86.682","4.990","1.092","5.537","-10.008","5","3","4946.28","17602.40","28.1"],["002632","8.21","10.05","2.581","2.332","76.910","-0.275","1.983","-6.248","-16.828","6","1","11884.37","34150.49","34.8"],["002298","4.77","9.91","1.391","1.602","74.502","0.910","3.272","-1.332","-7.998","4","1","4161.85","16450.00","25.3"],["002599","6.45","10.07","4.535","5.132","71.281","5.281","11.392","4.648","-5.830","6","1","11387.03","32627.59","34.9"],["002087","1.30","4.84","0.349","0.711","70.189","-0.988","-2.291","-0.029","-0.316","0","2","367.38","1818.72","20.2"],["003004","22.75","10.01","1.380","0.605","66.010","1.835","1.557","2.150","-5.687","4","2","2144.98","6682.17","32.1"],["000815","10.09","10.03","2.204","1.568","62.974","1.822","0.173","-3.823","-22.557","2","1","14741.71","38896.33","37.9"],["000411","10.89","10.00","1.235","0.770","62.070","1.028","0.803","0.452","2.456","2","1","4212.10","14831.33","28.4"],["002388","4.50","6.13","1.288","3.420","56.003","1.128","1.768","0.001","-10.866","5","1","2915.09","17351.72","16.8"],["002793","4.52","9.98","0.544","0.371","51.094","0.561","0.476","2.295","2.262","5","1","2604.18","11945.79","21.8"],["000861","1.46","0.00","0.241","0.619","48.301","0.544","0.381","-3.005","-14.638","4","3","843.67","6203.45","13.6"],["002181","4.19","0.72","0.259","0.816","47.863","0.140","1.076","0.105","-9.027","6","2","1228.21","6978.45","17.6"]],"updatetime":"2024-03-08 15:00:00","total":1500,"page":1,"nowdate":"2024-03-09"}

TA的精华主题

TA的得分主题

发表于 2024-3-9 14:40 | 显示全部楼层
本帖最后由 smiletwo 于 2024-3-9 14:43 编辑

请问大神,这个如何取得?
1709966355372.png

TA的精华主题

TA的得分主题

 楼主| 发表于 2024-3-9 14:57 | 显示全部楼层

TA的精华主题

TA的得分主题

发表于 2024-3-9 15:19 | 显示全部楼层
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用  · 内置多项VBA编程加强工具       ★ 免费下载 ★      ★使用手册
smiletwo 发表于 2024-3-9 14:40
请问大神,这个如何取得?

Rnd()
应该 不要也行 是避免数据缓存的

评分

1

查看全部评分

TA的精华主题

TA的得分主题

发表于 2024-3-10 17:39 | 显示全部楼层
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件       ★免费下载 ★       ★ 使用帮助
莫悠悠 发表于 2024-3-8 20:43
以下脚本是我几年以前下载同样网站数据抓取的(忘记了作者名字),最近因为散户大家庭的数据经常断更没有 ...

这个 用了 ie
不需要 ie    也不需要 循环250次
可以搞
1.png

TA的精华主题

TA的得分主题

 楼主| 发表于 2024-3-10 17:44 | 显示全部楼层
perfect131 发表于 2024-3-10 17:39
这个 用了 ie
不需要 ie    也不需要 循环250次
可以搞

请赐教脚本

TA的精华主题

TA的得分主题

发表于 2024-3-10 17:46 | 显示全部楼层

TA的精华主题

TA的得分主题

 楼主| 发表于 2024-3-10 17:55 | 显示全部楼层
您需要登录后才可以回帖 登录 | 免费注册

本版积分规则

手机版|关于我们|联系我们|ExcelHome

GMT+8, 2024-9-29 20:30 , Processed in 0.032393 second(s), 8 queries , Gzip On, MemCache On.

Powered by Discuz! X3.4

© 1999-2023 Wooffice Inc.

沪公网安备 31011702000001号 沪ICP备11019229号-2

本论坛言论纯属发表者个人意见,任何违反国家相关法律的言论,本站将协助国家相关部门追究发言者责任!     本站特聘法律顾问:李志群律师

快速回复 返回顶部 返回列表