python读excel中的sheet
读取单个sheet
import openpyxl
from port_project.excel_api.api_keyword.api_key import ApiKey
# 读取excel
excel = openpyxl.load_workbook('../data/excel_demo.xlsx')
sheet = excel['Sheet1']
# 读取excel内容
for value in sheet.values:
print(value)
读取该excel里的全部sheet
import openpyxl
from port_project.excel_api.api_keyword.api_key import ApiKey
# 读取excel
excel = openpyxl.load_workbook('../data/excel_demo.xlsx')
# 获取workbook中全部的表格
sheets = excel.sheetnames
# print(sheets)
# 循环遍历全部sheet
for name in range(len(sheets)):
sheet = excel[sheets[name]]
print(sheet.title)
# 读取excel内容，实现文件驱动自动化执行
for value in sheet.values:
if type(value[0]) is int:
print(value)
