股票代码导出－－htm网页分析抓取

gareth

想将网页的股票代码及日期导出到EXCEL，有老师指点一下么，多谢了！
{"errorcode":0,"errormsg":"","result":{"select":{"successRate":68,"size":145,"list":[{"code":"300284","date":"2016-09-05"},{"code":"300312","date":"2016-09-05"},{"code":"300348","date":"2016-09-05"},{"code":"300352","date":"2016-09-05"},{"code":"300356","date":"2016-09-05"},{"code":"300363","date":"2016-09-05"},{"code":"300428","date":"2016-09-05"},{"code":"300429","date":"2016-09-05"},{"code":"300432","date":"2016-09-05"},{"code":"300438","date":"2016-09-05"},{"code":"300444","date":"2016-09-05"},{"code":"300459","date":"2016-09-05"},{"code":"300464","date":"2016-09-05"},{"code":"300468","date":"2016-09-05"},{"code":"300470","date":"2016-09-05"},{"code":"300479","date":"2016-09-05"},{"code":"300490","date":"2016-09-05"},{"code":"300505","date":"2016-09-05"},{"code":"300509","date":"2016-09-05"},{"code":"300512","date":"2016-09-05"},{"code":"600006","date":"2016-09-05"}]}}}
test.rar (9.5 KB, 下载次数: 104)

2016-9-6 14:08 上传

点击文件名下载附件
股票代码导出

gareth

在线等，高手现身....

liu-aguang

liu-aguang

test.rar (16.73 KB, 下载次数: 210)

2016-9-6 15:25 上传

点击文件名下载附件

gareth

liu-aguang 发表于 2016-9-6 15:25

多谢老师出手，非常好用！！

ione_fox

Mark 学习  用length 得到list数组的元素的数量然后遍历

dsunway

真是太强了，效率很高