Skip to content
Snippets Groups Projects
Select Git revision
  • 6e9f81bbdc04b13d44da44259686d1ab5970752b
  • master default protected
2 results

excel-access-via-java-c-sharp-python-demo

  • Clone with SSH
  • Clone with HTTPS
  • user avatar
    .
    finnf authored
    6e9f81bb
    History

    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:

    1. 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#:

    1. PIA (Primary Interop Assemblies)
      a) Installed Office version (includes installed Primary Interop Assemblies)
      b) Installed Primary Interop Assemblies

    Python:

    1. 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