import os
import openpyxl
path = r"D:\PyCharm\pythonProject1"#查找文件路径
os.chdir(path)#修改工作路径
workbook = openpyxl.load_workbook('excel.xlsx')#返回一个workbook类型数据
sheet = workbook.active#获取活动表
cell1 = sheet['C1:C5'] #获取C8到C21的数据
for i in cell1:
for j in i:
print(j.value)
得到的全是None