python 批量生成测试数据并导出为excel 简单案例

#先导入Faker
from faker import Faker,Factory
import xlwt
f=Faker(locale='zh_cn')
ws=xlwt.Workbook()
shet=ws.add_sheet(u'abc')
path=r"C:\Users\user\Desktop\123.xlsx"
n=0
while n<=100:
        n+=1
        shet.write(n,0,f.name())#第一个参数表示行，第二个表示列,第三个自己需要的数据
        shet.write(n,1,f.phone_number())
        shet.write(n,2,f.address())
        ws.save(path)