Skip to main content
ashishkhadpe
Level 3
Jan 6, 2021 9:04 AM UTC
Solved

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

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Anudeep_Garnepudi
Anudeep_GarnepudiAccepted solution
Community Advisor
Jan 6, 2021 9:43 AM UTC

@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

 

AG

1 reply

Anudeep_Garnepudi
Community Advisor
Anudeep_GarnepudiCommunity AdvisorAccepted solution
Community Advisor
Jan 6, 2021 9:43 AM UTC

@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

 

Translate
AG