Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

[AEM Gems Webinar] Accelerating Experience Manager as a Cloud Service development with Rapid Development Environments
Adobe Summit 2023 | Complete list of AEM Sessions & Labs
SOLVED

java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Cell.setCellType

Avatar

Level 3

We have an excel import functionality in our project and have below dependency for org.apache.poi

 

<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.7</version>
</dependency>

 

This was working fine until AEM 6.2 but breaking when upgraded to AEM 6.5.6. Please advice the jar version.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

@ashishkhadpe 

org.apache.poi.ss.usermodel.Cell.setCellType is deprecated. Use the latest POI jar then compile and deploy code.

https://poi.apache.org/apidocs/dev/org/apache/poi/ss/usermodel/Cell.html

 

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

@ashishkhadpe 

org.apache.poi.ss.usermodel.Cell.setCellType is deprecated. Use the latest POI jar then compile and deploy code.

https://poi.apache.org/apidocs/dev/org/apache/poi/ss/usermodel/Cell.html