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

Adobe Summit 2023 [19th to 23rd March, Las Vegas and Virtual] | Complete AEM Session & Lab list
SOLVED

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

Avatar

Level 4

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