在PyCharm项目中尝试导入xlwings时遇到以下错误：
C:Users[USERNAME]venvScriptspython.exe "C:Program FilesJetBrainsPyCharm 2021.3.2pluginspythonhelperspydevpydevconsole.py" --mode=client --port=62345
import sys; print('Python %s on %s' % (sys.version, sys.platform))
sys.path.extend(['C:\Users\[USERNAME]\PycharmProjects\Charge_Corrections_Setup', 'C:/Users/[USERNAME]/PycharmProjects/Charge_Corrections_Setup'])
PyDev console: starting.
Python 3.10.2 (tags/v3.10.2:a58ebcc, Jan 17 2022, 14:12:15) [MSC v.1929 64 bit (AMD64)] on win32
>>> import xlwings as xw
Traceback (most recent call last):
File "C:Users[USERNAME]AppDataLocalProgramsPythonPython310libimportlib_common.py", line 89, in _tempfile
os.write(fd, reader())
File "C:Users[USERNAME]AppDataLocalProgramsPythonPython310libimportlibabc.py", line 371, in read_bytes
with self.open('rb') as strm:
File "C:Users[USERNAME]AppDataLocalProgramsPythonPython310libimportlib_adapters.py", line 54, in open
raise ValueError()
ValueError
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:Users[USERNAME]AppDataLocalProgramsPythonPython310libcode.py", line 90, in runcode
exec(code, self.locals)
File "<input>", line 1, in <module>
File "C:Program FilesJetBrainsPyCharm 2021.3.2pluginspythonhelperspydev_pydev_bundlepydev_import_hook.py", line 21, in do_import
module = self._system_import(name, *args, **kwargs)
File "C:Users[USERNAME]venvlibsite-packagesxlwings__init__.py", line 36, in <module>
from .main import (
File "C:Program FilesJetBrainsPyCharm 2021.3.2pluginspythonhelperspydev_pydev_bundlepydev_import_hook.py", line 21, in do_import
module = self._system_import(name, *args, **kwargs)
File "C:Users[USERNAME]venvlibsite-packagesxlwingsmain.py", line 2754, in <module>
from . import conversion
File "C:Program FilesJetBrainsPyCharm 2021.3.2pluginspythonhelperspydev_pydev_bundlepydev_import_hook.py", line 21, in do_import
module = self._system_import(name, *args, **kwargs)
File "C:Users[USERNAME]venvlibsite-packagesxlwingsconversion__init__.py", line 19, in <module>
from .standard import (
File "C:Program FilesJetBrainsPyCharm 2021.3.2pluginspythonhelperspydev_pydev_bundlepydev_import_hook.py", line 21, in do_import
module = self._system_import(name, *args, **kwargs)
File "C:Users[USERNAME]venvlibsite-packagesxlwingsconversionstandard.py", line 12, in <module>
from ..pro import Markdown
File "C:Program FilesJetBrainsPyCharm 2021.3.2pluginspythonhelperspydev_pydev_bundlepydev_import_hook.py", line 21, in do_import
module = self._system_import(name, *args, **kwargs)
File "C:Users[USERNAME]venvlibsite-packagesxlwingspro__init__.py", line 15, in <module>
from .embedded_code import runpython_embedded_code, dump_embedded_code
File "C:Program FilesJetBrainsPyCharm 2021.3.2pluginspythonhelperspydev_pydev_bundlepydev_import_hook.py", line 21, in do_import
module = self._system_import(name, *args, **kwargs)
File "C:Users[USERNAME]venvlibsite-packagesxlwingsproembedded_code.py", line 22, in <module>
from .module_permissions import verify_execute_permission
File "C:Program FilesJetBrainsPyCharm 2021.3.2pluginspythonhelperspydev_pydev_bundlepydev_import_hook.py", line 21, in do_import
module = self._system_import(name, *args, **kwargs)
File "C:Users[USERNAME]venvlibsite-packagesxlwingspromodule_permissions.py", line 22, in <module>
import requests
File "C:Program FilesJetBrainsPyCharm 2021.3.2pluginspythonhelperspydev_pydev_bundlepydev_import_hook.py", line 21, in do_import
module = self._system_import(name, *args, **kwargs)
File "C:Users[USERNAME]venvlibsite-packagesrequests__init__.py", line 133, in <module>
from . import utils
File "C:Program FilesJetBrainsPyCharm 2021.3.2pluginspythonhelperspydev_pydev_bundlepydev_import_hook.py", line 21, in do_import
module = self._system_import(name, *args, **kwargs)
File "C:Users[USERNAME]venvlibsite-packagesrequestsutils.py", line 27, in <module>
from . import certs
File "C:Program FilesJetBrainsPyCharm 2021.3.2pluginspythonhelperspydev_pydev_bundlepydev_import_hook.py", line 21, in do_import
module = self._system_import(name, *args, **kwargs)
File "C:Users[USERNAME]venvlibsite-packagesrequestscerts.py", line 15, in <module>
from certifi import where
File "C:Program FilesJetBrainsPyCharm 2021.3.2pluginspythonhelperspydev_pydev_bundlepydev_import_hook.py", line 21, in do_import
module = self._system_import(name, *args, **kwargs)
File "<frozen importlib._bootstrap>", line 1027, in _find_and_load
File "<frozen importlib._bootstrap>", line 1006, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 688, in _load_unlocked
File "C:Users[USERNAME]venvlibsite-packageswraptimporter.py", line 170, in exec_module
notify_module_loaded(module)
File "C:Users[USERNAME]venvlibsite-packageswraptdecorators.py", line 470, in _synchronized
return wrapped(*args, **kwargs)
File "C:Users[USERNAME]venvlibsite-packageswraptimporter.py", line 136, in notify_module_loaded
hook(module)
File "C:Users[USERNAME]venvlibsite-packagescertifi_win32wrapt_certifi.py", line 20, in apply_patches
certifi_win32.wincerts.CERTIFI_PEM = certifi.where()
File "C:Users[USERNAME]venvlibsite-packagescertificore.py", line 37, in where
_CACERT_PATH = str(_CACERT_CTX.__enter__())
File "C:Users[USERNAME]AppDataLocalProgramsPythonPython310libcontextlib.py", line 135, in __enter__
return next(self.gen)
File "C:Users[USERNAME]AppDataLocalProgramsPythonPython310libimportlib_common.py", line 95, in _tempfile
os.remove(raw_path)
PermissionError: [WinError 32] The process cannot access the file because it is being used by another process: 'C:\Users\[USERNAME]\AppData\Local\Temp\tmp_g611hdf'
import xlwings as xw
Traceback (most recent call last):
File "C:Users[USERNAME]AppDataLocalProgramsPythonPython310libimportlib_common.py", line 89, in _tempfile
os.write(fd, reader())
File "C:Users[USERNAME]AppDataLocalProgramsPythonPython310libimportlibabc.py", line 371, in read_bytes
with self.open('rb') as strm:
File "C:Users[USERNAME]AppDataLocalProgramsPythonPython310libimportlib_adapters.py", line 54, in open
raise ValueError()
ValueError
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:Users[USERNAME]AppDataLocalProgramsPythonPython310libcode.py", line 90, in runcode
exec(code, self.locals)
File "<input>", line 1, in <module>
File "C:Program FilesJetBrainsPyCharm 2021.3.2pluginspythonhelperspydev_pydev_bundlepydev_import_hook.py", line 21, in do_import
module = self._system_import(name, *args, **kwargs)
File "C:Users[USERNAME]venvlibsite-packagesxlwings__init__.py", line 36, in <module>
from .main import (
File "C:Program FilesJetBrainsPyCharm 2021.3.2pluginspythonhelperspydev_pydev_bundlepydev_import_hook.py", line 21, in do_import
module = self._system_import(name, *args, **kwargs)
File "C:Users[USERNAME]venvlibsite-packagesxlwingsmain.py", line 2754, in <module>
from . import conversion
File "C:Program FilesJetBrainsPyCharm 2021.3.2pluginspythonhelperspydev_pydev_bundlepydev_import_hook.py", line 21, in do_import
module = self._system_import(name, *args, **kwargs)
File "C:Users[USERNAME]venvlibsite-packagesxlwingsconversion__init__.py", line 19, in <module>
from .standard import (
File "C:Program FilesJetBrainsPyCharm 2021.3.2pluginspythonhelperspydev_pydev_bundlepydev_import_hook.py", line 21, in do_import
module = self._system_import(name, *args, **kwargs)
File "C:Users[USERNAME]venvlibsite-packagesxlwingsconversionstandard.py", line 12, in <module>
from ..pro import Markdown
File "C:Program FilesJetBrainsPyCharm 2021.3.2pluginspythonhelperspydev_pydev_bundlepydev_import_hook.py", line 21, in do_import
module = self._system_import(name, *args, **kwargs)
File "C:Users[USERNAME]venvlibsite-packagesxlwingspro__init__.py", line 15, in <module>
from .embedded_code import runpython_embedded_code, dump_embedded_code
File "C:Program FilesJetBrainsPyCharm 2021.3.2pluginspythonhelperspydev_pydev_bundlepydev_import_hook.py", line 21, in do_import
module = self._system_import(name, *args, **kwargs)
File "C:Users[USERNAME]venvlibsite-packagesxlwingsproembedded_code.py", line 22, in <module>
from .module_permissions import verify_execute_permission
File "C:Program FilesJetBrainsPyCharm 2021.3.2pluginspythonhelperspydev_pydev_bundlepydev_import_hook.py", line 21, in do_import
module = self._system_import(name, *args, **kwargs)
File "C:Users[USERNAME]venvlibsite-packagesxlwingspromodule_permissions.py", line 22, in <module>
import requests
File "C:Program FilesJetBrainsPyCharm 2021.3.2pluginspythonhelperspydev_pydev_bundlepydev_import_hook.py", line 21, in do_import
module = self._system_import(name, *args, **kwargs)
File "C:Users[USERNAME]venvlibsite-packagesrequests__init__.py", line 133, in <module>
from . import utils
File "C:Program FilesJetBrainsPyCharm 2021.3.2pluginspythonhelperspydev_pydev_bundlepydev_import_hook.py", line 21, in do_import
module = self._system_import(name, *args, **kwargs)
File "C:Users[USERNAME]venvlibsite-packagesrequestsutils.py", line 42, in <module>
DEFAULT_CA_BUNDLE_PATH = certs.where()
File "C:Users[USERNAME]venvlibsite-packagescertificore.py", line 37, in where
_CACERT_PATH = str(_CACERT_CTX.__enter__())
File "C:Users[USERNAME]AppDataLocalProgramsPythonPython310libcontextlib.py", line 135, in __enter__
return next(self.gen)
File "C:Users[USERNAME]AppDataLocalProgramsPythonPython310libimportlib_common.py", line 95, in _tempfile
os.remove(raw_path)
PermissionError: [WinError 32] The process cannot access the file because it is being used by another process: 'C:\Users\[USERNAME]\AppData\Local\Temp\tmpkn_ssllb'
第二部分似乎是访问日志的问题，所以我认为这没关系，但ValueError令人担忧。这是一系列导入的一部分，包括xlrd、openpyxl、xlsxwriter和其他模块，所以只有这个模块抛出错误是很奇怪的。
然而，当我开始进行故障排除时，我发现了一件更奇怪的事情：任何使用pip都会引发同样的一系列错误：
PS C:Users[USERNAME]PycharmProjectsReports> pip install seaborn
Traceback (most recent call last):
File "C:Users[USERNAME]AppDataLocalProgramsPythonPython310libimportlib_common.py", line 89, in _tempfile
os.write(fd, reader())
File "C:Users[USERNAME]AppDataLocalProgramsPythonPython310libimportlibabc.py", line 371, in read_bytes
with self.open('rb') as strm:
File "C:Users[USERNAME]AppDataLocalProgramsPythonPython310libimportlib_adapters.py", line 54, in open
raise ValueError()
ValueError
它还引发了文件访问问题，但为了节省空间，我省略了它。
我不知道这里的问题是什么，甚至不知道该去哪里看。我们刚刚在工作中更新了我们的web代理，但我昨天遇到了这个问题，相信我已经通过更新环境和PyCharm设置中的证书解决了这个问题。在这样做之后，pip和所有程序昨晚在注销前都在工作，但今天早上的第一件事是这个问题。
代理可能是问题所在，但我甚至不知道从哪里开始诊断我还没有做过的事情，尤其是因为值错误不是特定的。
如果有人知道去哪里看，或者根本原因是什么，我将不胜感激！
为了防止将来有人遇到这种情况，通过完全清除我的PyCharm安装并从头开始解决了这个问题。
尽我所能，这是由于安装了python-certificate-win32包，同时使用了一个相当复杂的web代理。PyCharm已经对代理提供的证书很挑剔，让python-certificate-win32干预这些证书似乎是一个进步。
过去似乎有类似问题的记录案例(请参阅此处(，但代理的添加将一个烦人的问题变成了一个坏问题，完全破坏了PIP，甚至不允许卸载包。
由于这是我所在组织的特定设置，我怀疑其他人是否会遇到这种情况，但以防万一，也许这会有所帮助。