python对Excel表格操作,,操作场景,给一个Ex
python对Excel表格操作,,操作场景,给一个Ex
操作场景,给一个Excel表格随机生成10万个手机号码
python中常见的对Excel操作模块
xlwt module 将数据写入Excel表
xlrd module 读取Excel表格
xlsxwriter modole xlwt模块的升级版,用于处理大量数据
先用xlwt写入Excel操作
import xlwt # 将数据写入Excelimport randombook = xlwt.Workbook(encoding=‘utf-8‘,style_compression=0) # 创建workbook对象,设置编码格式worksheet = book.add_sheet(‘test‘,cell_overwrite_ok=True) # 创建一个sheet对象,cell_overwrite_ok表示可以覆盖单元格worksheet.write(0,0,‘phone‘) # 在0,0位置写入phone,前面0代表列,后面0代表行# 手机开头号码prelist = ["130","131","132","133","134","135","136","137","138","139","147","150","151","152","153","155","156","157","158","159","186","187","188"]nums = 0for i in range(100000): # 组合成一个11位手机号码 phones = random.choice(prelist)+"".join(random.choice("0123456789") for i in range(8)) nums += 1 worksheet.write(nums,0,phones)book.save(r‘D:\python\test.xls‘)
执行后发现报错:ValueError: row index was 65536, not allowed by .xls format
原因是xlwt修改xls数据最多只能修改到65536行,所以只能使用新的模块xlsxwriter模块修改的文件是xlsx
用xlsxwriter模块修改Excel文件
import xlwt # 将数据写入Excelimport xlrd # 读取Excel文档from xlutils.copy import copyimport xlsxwriterimport randomworkbook = xlsxwriter.Workbook(r‘D:\python\test.xlsx‘) # 创建Excel文件worksheet = workbook.add_worksheet() # 创建一个sheet,不加名字默认sheetworksheet.write(0,0,"phone")# 手机开头号码prelist = ["130","131","132","133","134","135","136","137","138","139","147","150","151","152","153","155","156","157","158","159","186","187","188"]nums = 0for i in range(100000): # 组合成一个11位手机号码 phones = random.choice(prelist)+"".join(random.choice("0123456789") for i in range(8)) nums += 1 worksheet.write(nums,0,phones)workbook.close()
python对Excel表格操作
相关内容
- Python,PyCharm2017安装教程,包含注册码,,一,安装PyC
- python通过手机抓取微信公众号,,使用 Fiddler
- 分享《利用Python进行数据分析(第二版)》+源码+Wes Mcki
- Python中的异常处理的习题,,1 定义一个函数fu
- python开发之旅——面向对象【人狗大战】,,class Dog:
- 吴裕雄 python神经网络 手写数字图片识别(5),,impor
- 一个简单的监控redis性能的python脚本,,一个简单的监控
- python实现简易工资管理系统(Salary Manage)源码,,一、
- 小白学Python(17)——pyecharts 日历图 Calendar,,Calendar
- Python升级3.6.5,,创建目录python
评论关闭