Hi. I do struggle to create openpyxl on my PYCHARM(Windows 11). I have seen your tutorial but i ma still struggling to create it. Which other method can I used to create it?
which part of openpyxl are you struggling with?
What is the problem exactly you are Facing
When I create it using Pycharm inmy Windows PC it does not appear on the site packages. I followed all the instruction ast they appear on the 6h tutorial, I also followed another instruction from a website called geeksforgeeks.com but the outcomes are the same
I have the same issue. When I run pip command, I get a bunch of errors. I have also tried to run against the openpyexcel older package.
Here is what I get:
Copyright (C) Microsoft Corporation. All rights reserved.
Install the latest PowerShell for new features and improvements! Migrating from Windows PowerShell 5.1 to PowerShell 7 - PowerShell | Microsoft Learn
(venv) PS C:\Users\adlama\PycharmProjects\HelloWorld> pip install openpyxl
ERROR: Exception:
Traceback (most recent call last):
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\cli\base_command.py”, line 160, in exc_logging_wrapper
status = run_func(*args)
^^^^^^^^^^^^^^^
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\cli\req_command.py”, line 247, in wrapper
return func(self, options, args)
^^^^^^^^^^^^^^^^^^^^^^^^^
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\commands\install.py”, line 326, in run
session = self.get_default_session(options)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\cli\req_command.py”, line 98, in get_default_session
self._session = self.enter_context(self._build_session(options))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\cli\req_command.py”, line 125, in _build_session
session = PipSession(
^^^^^^^^^^^
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\network\session.py”, line 343, in init
self.headers[“User-Agent”] = user_agent()
^^^^^^^^^^^^
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\network\session.py”, line 175, in user_agent
setuptools_dist = get_default_environment().get_distribution(“setuptools”)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\metadata\importlib_envs.py”, line 188, in get_distribution
return next(matches, None)
^^^^^^^^^^^^^^^^^^^
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\metadata\importlib_envs.py”, line 183, in
matches = (
^
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\metadata\base.py”, line 612, in iter_all_distributions
for dist in self._iter_distributions():
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\metadata\importlib_envs.py”, line 176, in _iter_distributions
for dist in finder.find_eggs(location):
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\metadata\importlib_envs.py”, line 146, in find_eggs
yield from self._find_eggs_in_zip(location)
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\metadata\importlib_envs.py”, line 123, in _find_eggs_in_zip
from pip.vendor.pkg_resources import find_eggs_in_zip
File "C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_vendor\pkg_resources_init.py", line 2164, in
register_finder(pkgutil.ImpImporter, find_on_path)
^^^^^^^^^^^^^^^^^^^
AttributeError: module ‘pkgutil’ has no attribute ‘ImpImporter’. Did you mean: ‘zipimporter’?
Traceback (most recent call last):
File “”, line 198, in _run_module_as_main
File “”, line 88, in run_code
File "C:\Users\adlama\PycharmProjects\HelloWorld\venv\Scripts\pip.exe_main.py", line 7, in
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\cli\main.py”, line 70, in main
return command.main(cmd_args)
^^^^^^^^^^^^^^^^^^^^^^
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\cli\base_command.py”, line 101, in main
return self._main(args)
^^^^^^^^^^^^^^^^
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\cli\base_command.py”, line 216, in _main
self.handle_pip_version_check(options)
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\cli\req_command.py”, line 179, in handle_pip_version_check
session = self._build_session(
^^^^^^^^^^^^^^^^^^^^
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\cli\req_command.py”, line 125, in _build_session
session = PipSession(
^^^^^^^^^^^
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\network\session.py”, line 343, in init
self.headers[“User-Agent”] = user_agent()
^^^^^^^^^^^^
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\network\session.py”, line 175, in user_agent
setuptools_dist = get_default_environment().get_distribution(“setuptools”)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\metadata\importlib_envs.py”, line 188, in get_distribution
return next(matches, None)
^^^^^^^^^^^^^^^^^^^
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\metadata\importlib_envs.py”, line 183, in
matches = (
^
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\metadata\base.py”, line 612, in iter_all_distributions
for dist in self._iter_distributions():
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\metadata\importlib_envs.py”, line 176, in _iter_distributions
for dist in finder.find_eggs(location):
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\metadata\importlib_envs.py”, line 146, in find_eggs
yield from self._find_eggs_in_zip(location)
File “C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_internal\metadata\importlib_envs.py”, line 123, in _find_eggs_in_zip
from pip.vendor.pkg_resources import find_eggs_in_zip
File "C:\Users\adlama\PycharmProjects\HelloWorld\venv\Lib\site-packages\pip_vendor\pkg_resources_init.py", line 2164, in
register_finder(pkgutil.ImpImporter, find_on_path)
^^^^^^^^^^^^^^^^^^^
AttributeError: module ‘pkgutil’ has no attribute ‘ImpImporter’. Did you mean: ‘zipimporter’?
(venv) PS C:\Users\adlama\PycharmProjects\HelloWorld>
A screenshot would be better for me to know the problems you are facing
I am struggling to proceed. I don’t know what to do…
Did you try installing the openpyxl with the pip on your terminal
Yes… but it didn’t work. I decided to uninstall Pycharm and reinstall it.
If you have Vs code try running the code on Vscode and check don’t run on pycharm
Try running the code on Vscode