Forum Stats

  • 3,853,850 Users
  • 2,264,287 Discussions
  • 7,905,483 Comments

Discussions

Excel(xlsx) file validation issue in webcenter portal

User_112YD
User_112YD Member Posts: 12 Green Ribbon
edited Oct 25, 2019 3:07AM in WebCenter Portal

Hi Experts,

i'm facing one weird issue. i have to validate xls and xlsx files, for that i have added poi jars in adf application and i'm validating files accordingly.

when i'm deploying/integrating with webcenter(12.2.1.3) portal these adf taskflows then i'm facing with issue with xlsx file while reading. its throwing error like LitteEndian class not found. In my adf application i'm using poi 4.1 jars and its dependencies..but its pointing to some old POI jars in portal.

how to resolve this poi jars issue in portal ?

Note: i'm able to validate xls file in portal  but not able validate xlsx file.

Thanks in advance.

Best Answer

  • Daniel Merchán
    Daniel Merchán Enterprise Achitect Member Posts: 2,192 Gold Trophy
    edited Oct 10, 2019 4:13AM Answer ✓

    Hi,

    You have two options:

    • Check the current POI version of your WebCenter Portal installation and use the same for your custom development. If I remember correctly it is 3.10.

    • If you really need the latest Apache POI version loaded then you can try to setup the PRE_CLASSPATH variable in your setDomainEnv.sh to point a folder where you put your new Apache POI newest version and its dependencies.
      This will take your newest Apache POI version instead of the ones shipped within the Fusion Infrastructure.

    Kind regards.

Answers

  • Daniel Merchán
    Daniel Merchán Enterprise Achitect Member Posts: 2,192 Gold Trophy
    edited Oct 10, 2019 4:13AM Answer ✓

    Hi,

    You have two options:

    • Check the current POI version of your WebCenter Portal installation and use the same for your custom development. If I remember correctly it is 3.10.

    • If you really need the latest Apache POI version loaded then you can try to setup the PRE_CLASSPATH variable in your setDomainEnv.sh to point a folder where you put your new Apache POI newest version and its dependencies.
      This will take your newest Apache POI version instead of the ones shipped within the Fusion Infrastructure.

    Kind regards.