**
Python操作excle
**
使用:xlwt、xlrd、xlutils
- 介绍分类
官方提供
import xlwt,xlrd
from xlutils.copy import copy
data = xlrd.open_workbook('excel_test.xls',formatting_info=True)
excel = copy(wb=data) # 完成xlrd对象向xlwt对象转换
excel_table = excel.get_sheet(0) # 获得要操作的页
table = data.sheets()[0]
nrows = table.nrows # 获得行数
ncols = table.ncols # 获得列数
values = ["E","X","C","E","L"] # 需要写入的值
for value in values:
excel_table.write(nrows,1,value) # 因为单元格从0开始算,所以row不需要加一
nrows = nrows+1
excel.save('excel_test.xls')
自测代码
from xlrd import open_workbook
from xlutils.copy import copy
import os
excle_path = os.path.join(os.path.abspath('.'),'worker','人员信息.xls')
data = open_workbook(filename=excle_path) # 打开excel文件
excel = copy(wb = data)
excel_table = excel.get_sheet(0) # 根据Sheet1这个sheet名字来获取该sheet
table = data.sheets()[0]
name = 'wxt'
age = '12'
values = [name,age]
nrow = table.nrows
ncols = table.ncols
for i in values:
excel_table.write(1,nrow,i)
nrow+=1
excel.save('excle_test.xls')