美文网首页
格式化写入exl

格式化写入exl

作者: Tsukinousag | 来源:发表于2022-06-27 13:54 被阅读0次
    def writeData(news):
        workbook = xlwt.Workbook(encoding = 'utf-8')
        print(workbook)
        worksheet = workbook.add_sheet('MySheet')
    
        worksheet.write(0, 0, "标题")
        worksheet.write(0, 1, "时间")
        worksheet.write(0, 2, "媒体")
        worksheet.write(0, 3, "网址")
    
        for i in range(len(news)):
            #print(news[i])
            worksheet.write(i+1, 0, news[i]["origin_title"])
            worksheet.write(i+1, 1, news[i]["datetime"])
            worksheet.write(i+1, 2, news[i]["media"])
            worksheet.write(i+1, 3, news[i]["url"])
    
        workbook.save('data.xls')
    

    相关文章

      网友评论

          本文标题:格式化写入exl

          本文链接:https://www.haomeiwen.com/subject/glonvrtx.html