读操作
![](https://img-blog.csdnimg.cn/20200706104359345.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTkwMDgwOA==,size_16,color_FFFFFF,t_70)
import xlrd
xlsx = xlrd.open_workbook('G:/2020年6月28日夏季第二次派遣库.xlsx')
table = xlsx.sheet_by_index(0)
# 读取表格的值
print(table.cell_value(189, 3))
print(table.row(189)[3].value)
写操作
![](https://img-blog.csdnimg.cn/20200706104447503.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTkwMDgwOA==,size_16,color_FFFFFF,t_70)
import xlrd
import xlwt
# xlsx = xlrd.open_workbook('G:/2020年6月28日夏季第二次派遣库.xlsx')
# table = xlsx.sheet_by_index(0)
#
# # 读取表格的值
# print(table.cell_value(189, 3))
# print(table.row(189)[3].value)
newbook = xlwt.Workbook()
worksheet = newbook.add_sheet("newsheet")
worksheet.write(189, 3, "测试")
newbook.save('G:/2020年6月28日夏季第二次派遣库.xlsx')
用xlutils套用excel格式
![](https://img-blog.csdnimg.cn/20200707075408243.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTkwMDgwOA==,size_16,color_FFFFFF,t_70)