from openpyxl import load_workbook
import os
# 獲取excel路徑
cur_dir = os.path.dirname(os.path.abspath(__file__))
excel_path = os.path.join(cur_dir, "login_case.xlsx")
# 這就是打開excel
wb = load_workbook(excel_path)
# 通過表單名，獲取表單
sh = wb['case1']
# 獲取表頭
titles = []
for index in range(1, sh.max_columu+1):
value = sh.cell(1, index).value
print(value)
列印：
D:\python\python.exe D:/pythonwork/python_study/study/class13/讀取測驗用例資料.py
Traceback (most recent call last):
File "D:/pythonwork/python_study/study/class13/讀取測驗用例資料.py", line 11, in <module>
wb = load_workbook(excel_path)
File "D:\python\lib\site-packages\openpyxl\reader\excel.py", line 315, in load_workbook
reader.read()
File "D:\python\lib\site-packages\openpyxl\reader\excel.py", line 276, in read
self.read_workbook()
File "D:\python\lib\site-packages\openpyxl\reader\excel.py", line 148, in read_workbook
wb_part = _find_workbook_part(self.package)
File "D:\python\lib\site-packages\openpyxl\reader\excel.py", line 113, in _find_workbook_part
raise IOError("File contains no valid workbook part")
OSError: File contains no valid workbook part
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/132261.html
上一篇：jupyter notebook報錯[Errno 2] No such file or directory: 'C:/Users/Trick云/.jupyter