EXCEL之python 学习笔记（day 1）

EXCEL 打开，表格名称获取，数据大小获取，激活表格，获取表格内单元格中的值，单元格的值、行数、列数及坐标

#day 1
# TODO:1）打开Excel表格并获取表格名称
from openpyxl import load_workbook
workbook=load_workbook(filename='test.xlsx')
print(workbook.sheetnames)
# 通过  sheet 名称获取表格
sheet=workbook['Sheet1']
print(sheet)
#
# TODO:2）获取表格的尺寸大小( ( 几行几列数据) )
print(sheet.dimensions)
# TODO:3）获取表 格内某个格子的数据
# ① sheet["A 1"] 方式
workbook = load_workbook(filename = "test.xlsx")
# sheet = workbook.active
sheet=workbook['Sheet4']
print(sheet)
cell1 = sheet["A1"]
cell2 = sheet["C11"]
print(cell1.value, cell2.value)
"""
workbook.active 打开激活的表格；
sheet["A1"] 获取 A1 格子的数据；
cell.value 获取格子中的值；
"""

# ② sheet.cell(row=, column=) 方式
from openpyxl import load_workbook
workbook=load_workbook(filename='test.xlsx')
sheet=workbook['Sheet1']
print(sheet)
cell1=sheet.cell(row=11,column=1)
cell2=sheet.cell(row=11,column=7)
print(cell1.value,cell2.value)

# TODO:4）获取某个格子的行数、列数、坐标
from openpyxl import load_workbook
workbook=load_workbook(filename='test.xlsx')
sheet=workbook.active
cell1=sheet['A1']
cell2=sheet['C11']
print(cell2.value,cell2.row,cell2.column,cell2.coordinate)
print(cell1.value,cell1.row,cell1.column,cell1.coordinate)