Reading Excel (.xlsx) files | Community
Skip to main content
Singaiah_Chintalapudi
Singaiah_Chintalapudi
Level 7
May 12, 2017

Reading Excel (.xlsx) files

  • May 12, 2017
  • 1 reply
  • 6899 views

Hi,

I want to read the .xlsx files from dam. I am able to get the InputStream of this file from dam to pass it to Apache POI to read the data. However, in the run time, it is picking the below xml parser and throwing the error:

javax.xml.stream.FactoryConfigurationError: Provider com.bea.xml.stream.EventFactory not found

I've tested this in stand alone Java application and its working fine without the above xmlparser. 

I also deployed this Apache POI as a OSGI bundle to make sure Felix has all the dependencies it needs.

Thanks.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

varunmitra
Adobe Employee
varunmitraAdobe Employee
Adobe Employee
May 12, 2017

Hi

It's hard for us to debug the issue.

However, I worked on something similar a while back and I have attached that piece of code. The code works on jxl api's.

Give it a look and verify if you can get it to work.

 

Regards

Varun mitra

    Singaiah_Chintalapudi
    Singaiah_ChintalapudiAuthor
    Level 7
    May 12, 2017

    varunmitra wrote...

    Hi

    It's hard for us to debug the issue.

    However, I worked on something similar a while back and I have attached that piece of code. The code works on jxl api's.

    Give it a look and verify if you can get it to work.

     

    Regards

    Varun mitra

     

     

    Hi,

    This only supports older formats (.xls). I know this API and it works well in AEM. But we want to use the latest Apache POI which supports all the versions of excel files.

    Thanks.

      Singaiah_Chintalapudi
      Singaiah_ChintalapudiAuthor
      Level 7
      October 18, 2018

      Hello,

      This issue should be fixed after installing service packs/CFP's on AEM 6.1/6.2 instances. Please update the POI dependencies as well.

      <dependency>

        <groupId>org.apache.poi</groupId>

        <artifactId>poi-ooxml</artifactId>

        <version>4.0.0</version>

        </dependency>

        <dependency>

            <groupId>org.apache.commons</groupId>

            <artifactId>commons-compress</artifactId>

            <version>1.18</version>

        </dependency>

      Most of the community articles or blog posts talks about reading data from .xls (older version) files. Apache POI reads/writes both older (.xls)/Newer(.xlsx) excel files within AEM.

      Thanks.

        Terms & ConditionsAccessibility statement

        Loading footer...