Hi,
I am getting following error while reading xlsx file, for xls file it is working fine
java.lang.NoClassDefFoundError: Could not initialize class org.apache.poi.ooxml.util.DocumentHelper
at org.apache.poi.openxml4j.opc.internal.ContentTypeManager.parseContentTypesFile(ContentTypeManager.java:395)
at org.apache.poi.openxml4j.opc.internal.ContentTypeManager.<init>(ContentTypeManager.java:104)
at org.apache.poi.openxml4j.opc.internal.ZipContentTypeManager.<init>(ZipContentTypeManager.java:54)
at org.apache.poi.openxml4j.opc.ZipPackage.getPartsImpl(ZipPackage.java:256)
at org.apache.poi.openxml4j.opc.OPCPackage.getParts(OPCPackage.java:742)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:315)
at org.apache.poi.ooxml.util.PackageHelper.open(PackageHelper.java:47)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:299)
at com.amoeboids.apps.util.SftpClientUtil.getTeamExcelData(SftpClientUtil.java:377)
at com.amoeboids.apps.util.SftpClientUtil.readHrmsJschFile(SftpClientUtil.java:188)
at com.amoeboids.apps.util.SftpClientUtil.readHrmsFile(SftpClientUtil.java:137)
at com.amoeboids.apps.service.settings.impl.AbstractSettingServiceImpl.hrmsSyncDataEvent(AbstractSettingServiceImpl.java:1687)
at com.amoeboids.apps.service.settings.impl.AbstractSettingServiceImpl.hrmsSyncAutoRun(AbstractSettingServiceImpl.java:1130)
at com.amoeboids.apps.service.scheduler.job.HrmsSyncJobHandler.runHrmsSyncJob(HrmsSyncJobHandler.java:15)
at com.amoeboids.apps.server.service.scheduler.job.HrmsSyncJob.processJob(HrmsSyncJob.java:21)
at com.amoeboids.apps.server.service.scheduler.impl.BaseAppJobRunner.runJob(BaseAppJobRunner.java:23)
at com.atlassian.scheduler.core.JobLauncher.runJob(JobLauncher.java:134)
at com.atlassian.scheduler.core.JobLauncher.launchAndBuildResponse(JobLauncher.java:106)
at com.atlassian.scheduler.core.JobLauncher.launch(JobLauncher.java:90)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.launchJob(CaesiumSchedulerService.java:435)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeClusteredJob(CaesiumSchedulerService.java:430)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeClusteredJobWithRecoveryGuard(CaesiumSchedulerService.java:454)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeQueuedJob(CaesiumSchedulerService.java:382)
at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.executeJob(SchedulerQueueWorker.java:66)
at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.executeNextJob(SchedulerQueueWorker.java:60)
at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.run(SchedulerQueueWorker.java:35)
at java.lang.Thread.run(Thread.java:748)
please suggest solution for this issue thank you!
Used dependencies
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>5.0.0</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>5.0.0</version>
</dependency>
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.