python写入内容到Excel文件中

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)

#效果图

 

posted @ 2020-07-21 16:14  千君君  阅读(1927)  评论(0编辑  收藏  举报