在Mac上使用xlwings，出现了以下问题。

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'

同款错误，又解决方案嘛

xw.Book吧。。

官网api： https://docs.xlwings.org/en/stable/quickstart.html https://docs.xlwings.org/en/stable/quickstart.html

参考： https://blog.csdn.net/baidu_39372836/article/details/90142315 https://blog.csdn.net/baidu_39372836/article/details/90142315

import xlwings as xw
wb = xw.Book(r'F:\vba\sheet内容提取\getcontent.xlsm')
sheet = wb.sheets["sheet1"]
print(sheet.name)