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

SOLVED

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

ashishkhadpe
Level 3
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
Anudeep_Garnepudi
Correct answer by
Community Advisor
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
Anudeep_Garnepudi
Correct answer by
Community Advisor
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