首页 > 技术文章 > python写入内容到Excel文件中

qianjunjun 2020-07-21 16:14 原文

import xlwt

def writeExcelFile(filename,content):
workbook = xlwt.Workbook(encoding='utf-8')
booksheet = workbook.add_sheet('信息表',cell_overwrite_ok=True)
  #循环存入
for i in range(0, len(content)):
for j in range(0, len(content)):
booksheet.write(j, i, content[i][j])

workbook.save(filename) #保存

if __name__ == '__main__':
content = [["name", "jim", "hmm", "lilei"], ["sex", "man", "woman", "man"], ["age", 19, 24, 24], ["country", "USA", "CHN", "CHN"]]
writeExcelFile('员工信息表.xls',content)

#效果图

 

推荐阅读