Code_1:
wb = xw.Book('/Users/shiwenhao/Documents/hp.xlsx')
sheet = wb.sheets["sheet1"]
print(sheet.name)
But...
```python
File "/Users/shiwenhao/PycharmProjects/Excel/venv/lib/python3.8/site-packages/aeosa/appscript/reference.py", line 482, in __call__
return self.AS_appdata.target().event(self._code, params, atts, codecs=self.AS_appdata).send(timeout, sendflags)
File "/Users/shiwenhao/PycharmProjects/Excel/venv/lib/python3.8/site-packages/aeosa/aem/aemsend.py", line 92, in send
raise EventError(errornum, errormsg, eventresult)
aem.aemsend.EventError: Command failed: The user has declined permission. (-1743)
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/Users/shiwenhao/PycharmProjects/Excel/main.py", line 3, in <module>
wb = xw.Book('/Users/shiwenhao/Documents/hp.xlsx')
File "/Users/shiwenhao/PycharmProjects/Excel/venv/lib/python3.8/site-packages/xlwings/main.py", line 668, in __init__
for wb in app.books:
File "/Users/shiwenhao/PycharmProjects/Excel/venv/lib/python3.8/site-packages/xlwings/main.py", line 61, in __iter__
for impl in self.impl:
File "/Users/shiwenhao/PycharmProjects/Excel/venv/lib/python3.8/site-packages/xlwings/_xlmac.py", line 265, in __iter__
n = len(self)
File "/Users/shiwenhao/PycharmProjects/Excel/venv/lib/python3.8/site-packages/xlwings/_xlmac.py", line 228, in __len__
return self.app.xl.count(each=kw.workbook)
File "/Users/shiwenhao/PycharmProjects/Excel/venv/lib/python3.8/site-packages/aeosa/appscript/reference.py", line 518, in __call__
raise CommandError(self, (args, kargs), e, self.AS_appdata) from e
appscript.reference.CommandError: Command failed:
OSERROR: -1743
MESSAGE: The user has declined permission.
COMMAND: app(pid=7665).count(each=k.workbook)```
And the code_2:
```python
import xlwings as xw
wb = xw.WorkBook('/Users/shiwenhao/Documents/hp.xlsx')
sheet = wb.sheets["sheet1"]
print(sheet.name)```
但是:
python Traceback (most recent call last): File "/Users/shiwenhao/PycharmProjects/Excel/main.py", line 3, in wb = xw.WorkBook('/Users/shiwenhao/Documents/hp.xlsx') AttributeError: module 'xlwings' has no attribute 'WorkBook'