python自动化办公(第6~7课)模块介绍,读取excel表格内容
Excel中的术语
- 打开Excel表格并获取工作表名称
from openpyxl import load_workbook
workbook = load_workbook(filename="阿里云天池电商婴儿用户数据.xlsx")
print(workbook.sheetnames)
['sheet表1']
- 通过sheet名获取表格并获取表格的尺寸大小
- sheet=workbook[工作表名称]
- sheet.dimensions
from openpyxl import load_workbook
workbook = load_workbook(filename="阿里云天池电商婴儿用户数据.xlsx")
sheet = workbook["sheet表1"]
print(sheet.dimensions)
print(type(sheet.dimensions))
A1:G1002
<class 'str'>
- 获取表格内某个格子的数据
- workbook.active 打开活跃的/唯一的表格
- sheet[“A1”] 获取A1格子
- cell.value 该格子的数据
from openpyxl import load_workbook
workbook = load_workbook(filename="阿里云天池电商婴儿用户数据.xlsx")
sheet = workbook.active
cell1 = sheet["A1"<