python自动化办公–excel
- excel读取
使用库:openpyxl- 读取excel文件
from openpyxl import load_workbook
exl = load_workbook(filename = 'test.xlsx')
print(exl.sheetnames)
- 打印工作表名
print(ex1.sheetnames)
- 打印文件内容区域范围
sheet = ex1.active
print(sheet.dimensions)
- 读取单元格
cell = sheet.cell(row=1,column=2) #指定行列数
print(cell.value)
cell_1 = sheet['A1'] #指定坐标
print(cell_1.value)