java.lang.NoSuchMethodError: org.apache.poi.ss.usermo...

[ashishkhadpe]

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.

[Anudeep_Garnepudi · Accepted solution]

@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