美文网首页
格式化写入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