Skip to content
Snippets Groups Projects
Select Git revision
  • master default protected
1 result

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

  • Clone with SSH
  • Clone with HTTPS
  • user avatar
    Michael Paffrath (mpaffrat) authored
    - updated README.md
    36c64e55
    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