pythonproxyopenpyxl

failure to install openpyxl with pip--how to overcome proxy


I am trying to install a python library, openpyxl. I just installed python 3.6 on my windows 10 work computer. The result of my installation attempt is below.

I found a related question: pip install and custom index url

If my problem is use of a proxy, is there something I can do to install openpyxl anyway?

C:\Users\00168070>pip install openpyxl

Collecting openpyxl Retrying (Retry(total=4, connect=None, read=None, redirect=None)) after connection broken by 'NewConnectionError>(': Failed to establish a new connection: [Errno 11002] getaddrinfo failed',)': /simple/openpyxl/

Retrying (Retry(total=3, connect=None, read=None, redirect=None)) after connection broken by 'NewConnectionError(': Failed to establish a new connection: [Errno 11002] getaddrinfo failed',)': /simple/openpyxl/

Retrying (Retry(total=2, connect=None, read=None, redirect=None)) after connection broken by 'NewConnectionError(': Failed to establish a new connection: [Errno 11002] getaddrinfo failed',)': /simple/openpyxl/

Retrying (Retry(total=1, connect=None, read=None, redirect=None)) after connection broken by 'NewConnectionError(': Failed to establish a new connection: [Errno 11002] getaddrinfo failed',)': /simple/openpyxl/

Retrying (Retry(total=0, connect=None, read=None, redirect=None)) after connection broken by 'NewConnectionError(': Failed to establish a new connection: [Errno 11002] getaddrinfo failed',)': /simple/openpyxl/

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

No matching distribution found for openpyxl


Solution

  • It seems that your local network status can not resolve the host name. Maybe be you can try to install that from source, below is my step:

    1:Download the source code:

    https://pypi.python.org/pypi/openpyxl
    

    2:Build and install:

    python3.6 setup.py install
    

    3:Output:

    .........
    creating dist
    creating 'dist/openpyxl-2.5.0-py3.6.egg' and adding 'build/bdist.linux-x86_64/egg' to it
    removing 'build/bdist.linux-x86_64/egg' (and everything under it)
    Processing openpyxl-2.5.0-py3.6.egg
    creating /usr/local/lib/python3.6/dist-packages/openpyxl-2.5.0-py3.6.egg
    Extracting openpyxl-2.5.0-py3.6.egg to /usr/local/lib/python3.6/dist-packages
    Adding openpyxl 2.5.0 to easy-install.pth file
    
    Installed /usr/local/lib/python3.6/dist-packages/openpyxl-2.5.0-py3.6.egg
    Processing dependencies for openpyxl==2.5.0
    Searching for et-xmlfile==1.0.1
    Best match: et-xmlfile 1.0.1
    Adding et-xmlfile 1.0.1 to easy-install.pth file
    
    Using /usr/local/lib/python3.6/dist-packages
    Searching for jdcal==1.3
    Best match: jdcal 1.3
    Adding jdcal 1.3 to easy-install.pth file
    
    Using /usr/local/lib/python3.6/dist-packages
    Finished processing dependencies for openpyxl==2.5.0
    

    4:Import and using:

    Python 3.6.3 (default, Oct  6 2017, 08:44:35)
    [GCC 5.4.0 20160609] on linux
    Type "help", "copyright", "credits" or "license" for more information.
    >>> from openpyxl import Workbook
    >>>