use snippet save dom to excel

1.打开贴吧

http://tieba.baidu.com/f?ie=utf-8&kw=python&fr=search

2.打开console执行下面命令

Array.prototype.toTable = function() {

    var tab = '';

    var th = '';

    th = "<tr><th>" + keys(this[0]).join('</th><th>') + "</th></tr>";

    this.forEach(function(a) {

        tab += "<tr><td>" + values(a).join('</td><td>') + "</td></tr>";

    });

    copy("<table>" + th + tab + "<table>");

};

 

var ar = [];

$$('#thread_list > li > div > div.col2_right.j_threadlist_li_right > div.threadlist_lz.clearfix > div.threadlist_title.pull_left.j_th_tit > a')

.forEach(function(a) {

ar.push({ domain: a.href.split('/')[2], url: a.href, title: a.innerHTML});

 });

ar.toTable();

3.打开一个excel,ctrl+v.自己看效果

posted @ 2019-01-30 14:01  公众号python学习开发  阅读(167)  评论(0编辑  收藏  举报