We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Unable to install openpyxl - 2023.1

mystasz
8 - Asteroid

Hi Community,

 

I'm on Alteryx server and intelligence suite version 2023.1 as of last week. Today I'm trying to write a python script and started off by realizing openpyxl is not installed. Here's what I've done to install it:

 

1) Closed designer

2) Opened as administrator 

3) Dragged the python tool onto canvas 

4) Uncommented the first line and put: Package.installPackages(['openpyxl'])

 

Any idea how to solve this?

 

WARNING: Retrying (Retry(total=0, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ConnectTimeoutError(<pip._vendor.urllib3.connection.HTTPSConnection object at 0x000001CF131069D0>, 'Connection to pypi.org timed out. (connect timeout=15)')': /simple/openpyxl/

ERROR: Could not find a version that satisfies the requirement openpyxl (from versions: none)

ERROR: No matching distribution found for openpyxl

---------------------------------------------------------------------------

CalledProcessError                        Traceback (most recent call last)

<ipython-input-1-27f1bcd79a4a> in <module>

      2 # script here (only missing packages will be installed)

      3 from ayx import Package

----> 4 Package.installPackages(['openpyxl'])

 

c:\program files\alteryx\bin\miniconda3\envs\designerbasetools_venv\lib\site-packages\ayx\Package.py in installPackages(package, install_type, debug)

    200     print(pip_install_result["msg"])

    201     if not pip_install_result["success"]:

--> 202         raise pip_install_result["err"]

 

c:\program files\alteryx\bin\miniconda3\envs\designerbasetools_venv\lib\site-packages\ayx\Utils.py in runSubprocess(args_list, debug)

    118

    119     try:

--> 120         result = subprocess.check_output(args_list, stderr=subprocess.STDOUT)

    121         if debug:

    122             print("[Subprocess success!]")

 

c:\program files\alteryx\bin\miniconda3\envs\designerbasetools_venv\lib\subprocess.py in check_output(timeout, *popenargs, **kwargs)

    409         kwargs['input'] = '' if kwargs.get('universal_newlines', False) else b''

    410

--> 411     return run(*popenargs, stdout=PIPE, timeout=timeout, check=True,

    412                **kwargs).stdout

    413

 

c:\program files\alteryx\bin\miniconda3\envs\designerbasetools_venv\lib\subprocess.py in run(input, capture_output, timeout, check, *popenargs, **kwargs)

    510         retcode = process.poll()

    511         if check and retcode:

--> 512             raise CalledProcessError(retcode, process.args,

    513                                      output=stdout, stderr=stderr)

    514     return CompletedProcess(process.args, retcode, stdout, stderr)

 

CalledProcessError: Command '['c:\\program files\\alteryx\\bin\\miniconda3\\envs\\designerbasetools_venv\\python.exe', '-I', '-m', 'pip', 'install', 'openpyxl']' returned non-zero exit status 1.

1 REPLY 1
binuacs
21 - Polaris

@mystasz  Seems that your Alteryx environment doesn't have direct internet access (common for security reasons), or access to PyPI is blocked/restricted via firewall or proxy, work with your IT team and allow access to the pypi

Labels
Top Solution Authors