Nick and Nick,
The following comments are not authoritative.
- openpyxl needs to be "installed" in the Jython install location using pip or equivalent.
- JMRI includes the standalone version of Jython 2.7.4 but there is no "Jython install" location.
- It is possible to run Jython from the command line: ?java -jar /Applications/JMRI/lib/jython-standalone-2.7.4.jar. ?This will not include the JMRI context.
- It appears that openpyxl supports Python3. ?The latest versions might not support Python 2.7.4.
- Recent releases of macOS only support Python3.
---------------------
I recommend using the CSV approach. ?Excel can export and import CSV files. ?There are several examples of using CSV files in the jython directory.
LogixNG can also use CSV files as a data source. ?However, writing a CSV file is not supported.
Dave Sand
----- Original message -----
Subject: Re: [jmriusers] How do I import openpyxl?
Date: Thursday, May 22, 2025 10:22 AM
Hi,?
?
This is what Copilot said about running openpyxl in Jython:
?
'Using openpyxl with Jython can be challenging. Openpyxl relies on certain Python features that may not be fully compatible with Jython, which runs on the Java Virtual Machine (JVM). Users have reported issues when trying to install and use openpyxl with Jython 2.7, including import errors and missing dependencies.
If you're working with Jython and need to handle Excel files, you might want to explore Apache POI, a Java-based library for working with Excel formats. Alternatively, consider using Python instead of Jython if openpyxl is essential for your project.
Would you like help finding an alternative approach?'
?
Regards
?
Nick
?
?
