IBM i Global

IBM i 

A space for professionals working with IBM’s integrated OS for Power systems to exchange ideas, ask questions, and share expertise on topics like RPG and COBOL development, application modernization, open source integration, system administration, and business continuity.


#Power


#IBMi
 View Only

  • 1.  Is openpyxl module available on the OSS IBM i?

    Posted Wed January 18, 2023 11:50 AM
    Hi,

    As I understand it openpyxl is a dependency of Pandas and I was expecting it to be installed when I installed Pandas.
    It turns out it didn't.

    Is openpyxl available on the IBM i and in that case how can it be installed?

    Thanks in advance for your help,
    Paulo

    ------------------------------
    Paulo Silva
    ------------------------------


  • 2.  RE: Is openpyxl module available on the OSS IBM i?

    Posted Wed January 18, 2023 01:17 PM

    Do this in a virtual environment or --user to install locally.

    Don't install globally.

    ~$ pip3 install openpyxl
    Collecting openpyxl
    Downloading openpyxl-3.0.10-py2.py3-none-any.whl (242 kB)
    |████████████████████████████████| 242 kB 8.6 MB/s
    Collecting et-xmlfile
    Downloading et_xmlfile-1.1.0-py3-none-any.whl (4.7 kB)
    Installing collected packages: et-xmlfile, openpyxl
    Successfully installed et-xmlfile-1.1.0 openpyxl-3.0.10



    ------------------------------
    Jack Woehr
    IBM Champion 2021 - 2023
    IBM Qiskit Advocate
    ------------------------------

    Original Message


  • 3.  RE: Is openpyxl module available on the OSS IBM i?

    Posted Thu January 19, 2023 06:08 PM
    Thanks Jack!
    May I ask why shouldn't I install it globally?

    ------------------------------
    Paulo Silva
    ------------------------------

    Original Message


Related Content