---

python库-操作Excel

openpyxl库

三个基本概念：workbooks(工作簿)，sheets(表), cells(单元格)

不支持打开xls格式的EXECL文件

打开EXCEL

from openpyxl import WorkBook
from openpyxl import load_workbook
wb = load_workbook('路径.xlsx') # 得到workbook对象
sheetnames = wb.sheetnames # 得到workbook里面的表名
ws = wb[sheetnames[index]] # 得到sheet表
ws.cell(row, column).value # 得到某行某列单元格的值
ws.cell(row, column).value = 'xxxx' # 重赋值
# 以行迭代指定单元格
for row in ws.iter_rows(min_row=3, max_row=5, min_col=2, max_col=5):
    print(*[r.values for r in row])
# 以列迭代指定单元格
for col in ws.iter_cols(min_row=3, max_row=5, min_col=2, max_col=5):
    print(*[c.values for c in col])
wb.save('xxx.xlsx')

创建EXCEL

import openpyxl
wb = WorkBook()
ws = wb.active
ws.cell(1,1).value = 'xxx'
for i in range(2,5):
    for j in range(2,6):
        ws.cell(i+1, j+1).value = i*j
wb.save('xxx.xlsx')

xlrd

---