python3 ---Excel表格操作（1）

from openpyxl import load_workbook
# 打开Excel表格，并获取表格名称
workbook = load_workbook(filename='E:\图书馆.xlsx')
# sheet页名称，返回列表
# print(workbook.sheetnames)
# 选择sheet页
# sheet = workbook['Sheet1']
# 选择活跃的表格
sheet = workbook.active
# 获取表格尺寸大小
# print(sheet.dimensions)
# 获取一个格子
cell = sheet['C3']
# cell = sheet[row=1, column=1]
# 获取一系列格子
cells = sheet['B']
# cells = sheet['A:C']
# cells = sheet[5]
# cells = sheet.iter_rows(min_row=2, max_row=20, min_col=3, max_col=5)
# 格子的值，行，列，坐标
# print(cell.value, cell.row, cell.column, cell.coordinate)
print(cell.value)




# 输出表内的无内容的格子数
num = 0
allcell = sheet[sheet.dimensions]
# print(type(allcell))
for rowcell in allcell:
    for onecell in rowcell:
        # print(onecell.value)
        if onecell.value == None:
            num += 1
print("表格中的空格子数为：{}个".format(num))