doubanSpider.py 文件源码

def print_book_lists_excel(book_lists, book_tag_lists):
    wb = Workbook(optimized_write=True)
    ws = []
    for i in range(len(book_tag_lists)):
        # utf8->unicode
        ws.append(wb.create_sheet(title=book_tag_lists[i].decode()))
    for i in range(len(book_tag_lists)):
        ws[i].append(['??', '??', '??', '????', '??', '???'])
        count = 1
        for bl in book_lists[i]:
            ws[i].append([count, bl[u'a'], float(bl[u'b']),
                          int(bl[2]), bl[3], bl[4]])
            count += 1
    save_path = 'book_list'
    for i in range(len(book_tag_lists)):
        save_path += ('-' + book_tag_lists[i].decode())
    save_path += '.xlsx'
    wb.save(save_path)