Python批量造数写入excell

Question

哪位兄弟知道python批量造数到excell怎么弄吗?比如我想要1000个随机手机号数字写入表格。

Answer 1

需求: 随机创建手机号，并存入excel

import random
from openpyxl import Workbook

def get_mobile_number():
    # 移动手机号段
    mobile_prefix = ['134', '135', '136', '137', '138', '139', '147', '150', '151', '152', '157', '158', '159', '178', '182', '183', '184', '187', '188', '198']
    
    # 随机选择一个手机号段
    prefix = random.choice(mobile_prefix)
    
    # 生成8位随机号码
    suffix = ''.join(random.choice('0123456789') for _ in range(8))
   
    return prefix + suffix

# 创建一个Workbook对象
wb = Workbook()

# 获取默认的Sheet
sheet = wb.active

# 写入表头
sheet.append(['手机号'])

# 随机生成1000个手机号并写入Excel文件
for _ in range(1000):
    mobile_number = get_mobile_number()
    sheet.append([mobile_number])

# 保存Excel文件
wb.save('1000_mobile_numbers.xlsx')