티스토리 뷰

네이버 키워드 검색한 결과에서 제목만 css selector로 뽑아서 엑셀파일 naver.xlsx로 저장하기

 

npm install --save cheerio-httpcli

 

npm install --save exceljs

var client = require('cheerio-httpcli');
var Excel = require('exceljs');

let exportToExcel = (fileName, list)=>{
    let workbook = new Excel.Workbook();
    let worksheet = workbook.addWorksheet('Sheet1');
    worksheet.columns = [
        { header:'제목', key:'title' }
    ];
    for(let item of list){
        worksheet.addRow({ title:item});
    }
    workbook.xlsx.writeFile(fileName).then(()=>{
        console.log("success");
    });
}
let printHttpResponse = (url)=>client.fetch(url, {}, function(err, $, res){
    if(err){ console.log("error:", err); return; }
    var body = $.html();
    var sh_blog_title = $(".sh_blog_title._sp_each_url._sp_each_title");

    var list = [];
    for(var i = 0 ; i < sh_blog_title.length ; i++) {
        var a = $(sh_blog_title[i]).attr('title');
        list.push(a);
    }
    exportToExcel("naver.xlsx", list);
});
let url = "https://search.naver.com/search.naver?where=post&sm=tab_jum&ie=utf8&query=%EB%B2%9A%EA%BD%83";
printHttpResponse(url);

 

 

end.

 

 

공지사항
최근에 올라온 글
최근에 달린 댓글
Total
Today
Yesterday
링크
«   2024/03   »
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31
글 보관함