>>> import openpyxl
>>> from openpyxl import workbook
Traceback (most recent call last):
File "<pyshell#1>", line 1, in <module>
from openpyxl import workbook
ImportError: cannot import name 'workbook' from 'openpyxl' (unknown location)
>>> from openpyxl import load_workbook
Traceback (most recent call last):
File "<pyshell#2>", line 1, in <module>
from openpyxl import load_workbook
ImportError: cannot import name 'load_workbook' from 'openpyxl' (unknown location)
>>>
一、看來openpyxl模塊是安裝了的。
二、不管是workbook還是load_workbook都不行。我嘗試給workbook、load_workbook后面放上括號，也不行的。
>>> from openpyxl import load_workbook()
SyntaxError: invalid syntax
>>> wb = openpyxl.load_workbook()
Traceback (most recent call last):
File "<pyshell#4>", line 1, in <module>
wb = openpyxl.load_workbook()
AttributeError: module 'openpyxl' has no attribute 'load_workbook'
請大家指教。
uj5u.com熱心網友回復：
>>> wb = openpyxl.load_workbook(pm.xlsx)Traceback (most recent call last):
File "<pyshell#5>", line 1, in <module>
wb = openpyxl.load_workbook(pm.xlsx)
AttributeError: module 'openpyxl' has no attribute 'load_workbook'
uj5u.com熱心網友回復：
from openpyxl import load_workbookfrom openpyxl import Workbook
https://blog.csdn.net/weixin_45903952/article/details/105311722
uj5u.com熱心網友回復：
wb = load_workbook('山川材料表.xlsx')https://blog.csdn.net/weixin_45903952/article/details/105188176
uj5u.com熱心網友回復：
復制過去試試，是不是有的大小寫不對也不行uj5u.com熱心網友回復：
收到。感謝！現在用以下代碼，試運行OK了：
import openpyxl
wb=openpyxl.load_workbook('檔案名.xlsx')
sheet = wb['檔案名']
uj5u.com熱心網友回復：
sheet = wb['檔案名'] 這里應該是作業表名，不是檔案名，uj5u.com熱心網友回復：
是的。謝謝指正。由于我的作業簿只有一個表，且二者名字一樣，所以出了這樣的謬誤。
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/62285.html