总结python之excel write(row,col,data)

1 pip install xlwt 

2 pip install faker

import xlwt
import faker
# 新建一个workbook对象
wb = xlwt.Workbook() 
# Excel的每个文件，里面可以有很多sheet，所以有了workbook，还需要新建sheet
sheet = wb.add_sheet("first sheet")  
head_data = ["姓名","地址","手机号","城市"]
# write函数写入，分别是write(x行 x列 数据)
for head in head_data:
    sheet.write(0,head_data.index(head),head)
fake = faker.Faker()
for i in range(1,100):
    sheet.write(i,0,fake.first_name()+" "+fake.last_name())
    sheet.write(i,1,fake.address())
    sheet.write(i,2,fake.phone_number())
    sheet.write(i,3,fake.phone.city())
wb.save("Virtual user.xls")