IBM i Global

 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?

    IBM Champion
    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