Excel Access via Java C Sharp Python Demo
This demo contains basic code to access Excel sheet data via the following programming languages:
- Java
- C#
- Python
Usage requirements:
Java:
- Downloaded Apache POI Libraries (https://poi.apache.org/)
a) Add necessary .xlsx POI libraries as external libraries in your Java IDE
b) Add necessary .xlsx POI libraries to your Java classpath and run the Main.java
C#:
- PIA (Primary Interop Assemblies)
a) Installed Office version (includes installed Primary Interop Assemblies)
b) Installed Primary Interop Assemblies
Python:
- Installed OpenPyXL Library (https://openpyxl.readthedocs.io/en/stable/#)
!Only tested against the following Environment! - Win10 - IntelliJ (Java) with Apache POI v5.0.0 - Visual Studio 2019 (C#) with installed Office 2016 => Microsoft Excel 16.0 Object Library - Visual Studio Code (Python 2.7) with installed OpenPyXL