在python中创建excel文件并写入数据【转】

# 导入包
import xlwt

# 造的模拟数据
re_list= [{'apple':"11.5","orage":"嗯10:00字","xigua":"8.0"},{'apple1':"111.5","orage":"100.9","xigua1":"80.0"}]
content=[item.pop("orage") for item in re_list if "orage" in item.keys() ]

# 循环变量造出的数据
for item in content:
    # 1、实例化一个execl对象xls=工作薄
    xls = xlwt.Workbook()
    # 2、实例化一个工作表，名叫Sheet1
    sht1 = xls.add_sheet('Sheet1')
    sht2 = xls.add_sheet('Sheet2')
    # 3、第一个参数是行，第二个参数是列，第三个参数是值
    sht1.write(0, 0, '姓名')
    sht1.write(0, 1, '性别')
    sht1.write(0, 2, '年龄')
    sht1.write(0, 3, '公司')
    # 4、模拟插入数据
    sht1.write(1, 0, str(item))
    sht1.write(1, 1, str(item))
    sht1.write(1, 2, str(item))
    sht1.write(1, 3, str(item))

    #操作第二个工作薄
    sht2.write(0, 0, '姓名2')
    sht2.write(0, 1, '性别2')
    sht2.write(0, 2, '年龄2')
    sht2.write(0, 3, '公司2')
    # 往第二张表中插入数据
    sht2.write(1, 0, str(item))
    sht2.write(1, 1, str(item))
    sht2.write(1, 2, str(item))
    sht2.write(1, 3, str(item))

    # 5、提交工作薄
    xls.save('./mydata.xls')

 

转载地址https://blog.csdn.net/qq_38839677/article/details/82151646