python导出excel，随机生成姓名、手机号

Super_King_

已于 2022-10-20 16:19:51 修改

阅读量1.4k

点赞数 3

分类专栏： Python 文章标签： python

于 2021-12-02 16:44:47 首次发布

本文链接： https://blog.csdn.net/Super_King_/article/details/121680817

版权

Python 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

朋友想要个随机手机号的excel，python写法比java简单些

不多说直接上代码

import xlwt
import random
from datetime import datetime

style0 = xlwt.easyxf('font: name Times New Roman, color-index red, bold on', num_format_str='#,##0.00')
style1 = xlwt.easyxf(num_format_str='D-MMM-YY')

wb = xlwt.Workbook()
ws = wb.add_sheet('A Test Sheet')

ws.write(0, 0, "姓名", style0)
ws.write(0, 1, "国家", style0)
ws.write(0, 2, "手机号", style0)
ws.write(0, 3, "单位", style0)
for i in range(1, 10000, 1):

    xing = '赵钱孙李周吴郑王金木水火土石天地日月星光江河湖海田泉风霜雨雪雷电山岭崖谷丘岩云雾浪'
    ming = '人间四月芳菲尽山寺桃花始胜开金木水火土石天地日月星光江河湖海田泉风霜雨雪雷电山岭崖谷丘岩云雾浪'
    x = random.choice(xing)
    m = "".join(random.choice(ming) for i in range(1, 3))
    name = x + m

    prelist = ["130", "131", "132", "133", "134", "135", "136", "137", "138", "139", "147", "150", "151", "152",
           "153", "155", "156", "157", "158", "159", "186", "187", "188"]
    randomPre = random.choice(prelist)
    Number = "".join(random.choice("0123456789") for i in range(8))
    phoneNum = randomPre +Number

    ws.write(i, 0, name)
    ws.write(i, 1, "中国大陆")
    ws.write(i, 2, phoneNum)
    ws.write(i, 3, "测试单位")
else:
    print("循环结束")

wb.save('E:\myPythonProject\example.xls')

导出效果