Libreoffice doesn't recognice the installed openpyxl module

[alexcape]

With your help I created a Libreoffice python-makro which runs perfect in Ubuntu20.04.
Some users need my macro in Windows10. So I installed (in my Windows dual boot) LibreOffice Community Version 7.1.5.2 and via pip the required openpyxl module.

repeating the command

py -3.8 -m pip install openpyxl

I get:

Requirement already satisfied: openpyxl in c:…\appdata\local\programs\python\python38\lib\site-packages (3.0.8)
Requirement already satisfied: et-xmlfile in c:…\appdata\local\programs\python\python38\lib\site-packages (from openpyxl) (1.1.0)

But when I start the macro via Llibreoffice → macros–> python -->macroname
I get an error saying:

…(<class ‘ImportError’>: No module named ‘openpyxl’ (or ‘openpyxl.load_workbook’ is unknown)…

any idea how to get the macro running in windows10

[karolus]

Try to append the path, insert above import openpyxl:

import sys
sys.path.append("c:…/appdata/local/programs/python/python38/lib/site-packages (3.0.8)")
…

why do you want to use openpyxl from inside LO?
LO itself have the capbilities to read|write Excel-files

[alexcape]

I’ve tried to append the path without success.
I can’t use the LO model because I didn’t check how to install the uno bridge in pycharm (though I tried it 2 days long). Furthermore I think openpyxl is more pythoniastic.

[flywire]

I use openpyxl to do the grunt work and load it back into calc for the user interface.

[Wanderer]

With Linux there is python preinstalled in the OS available, so LO is usually configured to use this.

Windows has no python so LO brings its own. Sadly this is no complete installation and it has no pip. If you install a “real” python, this is independent and not seen by LOs python.

So you can either copy your lib to the python in LO or try to install some PIP for this python.

You are not the first asking:

How do I install pip in Libreoffice's embedded Python on Linux? Macro Python

How do I install pip in Libreoffice’s embedded Python on Linux? I wanted to install the pylint package for use in VS Code and display the syntax errors, but I need the pip first. If I open Module.py in VS Code using system python, the VSCode Explorer Outline tab is blank and pylint doesn’t work in libreoffice macros. [image description] If I open Module.py in VS Code using libreoffice’s built-in python the VSCode Explorer Outline tab displays all the variables and functions of my macro, but …

Third option: You may call an external python via shell() like any external program and tell the external python to run your .py-module.

[mrkalvin]

see this topic:

Install Python Package for Libre Office

I use this ZazPip extension to install python packages in libreoffice via pip: https://git.cuates.net/elmau/zaz-pip/raw/branch/master/files/ZAZPip_v0.8.0.oxt It was developed by @elmau (Mauricio Baeza), has an explanatory video in Spanish, but it is very intuitive to understand: