poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 58090] New: Issue with XLSX parsing
Date Wed, 01 Jul 2015 11:19:06 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=58090

            Bug ID: 58090
           Summary: Issue with XLSX parsing
           Product: POI
           Version: 3.9-FINAL
          Hardware: Other
                OS: other
            Status: NEW
          Severity: major
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: yanamala1@gmail.com

Created attachment 32871
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=32871&action=edit
Trying to parse the attached XLSX file

Running the standalone application to process the email attachments (
XLS/XLSX/Word) in multi threaded environment. Following error is thrown while
parsing the XLSX file using the following piece of code. PArsing comes to an
halt and do not allow to process other XLSX files. It works only after the
application restart. Appreciate if you could provide a solution for this at the
earliest.( Attached the XLSX file )

 XSSFWorkbook workBook = new XSSFWorkbook(new
FileInputStream(inputFile.getPath()));
    try{
     XSSFFormulaEvaluator.evaluateAllFormulaCells(workBook);
    }catch(RuntimeException e){
     LOG.debug("Exception occurred while evealating formulas");
    }
    sheetsNum=workBook.getNumberOfSheets();
    return sheetsNum;



org.apache.poi.openxml4j.exceptions.InvalidFormatException: Can't read content
types part !
        at org.apache.poi.util.PackageHelper.open(PackageHelper.java:41)
        at
org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:204)
        at
com.highradius.caa.agents.DynamicRemittanceExcelAgent.getNumberOfSheets(DynamicRemittanceExcelAgent.java:427)
        at
com.highradius.caa.agents.DynamicRemittanceExcelAgent.parseRemittance(DynamicRemittanceExcelAgent.java:156)
        at
com.highradius.caa.syndication.framework.EmailAttachmentsParserAgent.run(EmailAttachmentsParserAgent.java:230)
        at
com.scraper.CashAppAgentProcessorAction.run(CashAppAgentProcessorAction.java:136)
        at
com.scraper.ScheduledAgentLauncher.immediatelyLaunchScheduledAgent(ScheduledAgentLauncher.java:266)
        at com.scraper.WrapperAgentAction.run(WrapperAgentAction.java:172)
        at sun.reflect.GeneratedMethodAccessor2565.invoke(Unknown Source)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at
org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)
        at
org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:264)
        at
org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
        at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.apache.poi.openxml4j.exceptions.InvalidFormatException: Can't
read content types part !
        at
org.apache.poi.openxml4j.opc.internal.ContentTypeManager.<init>(ContentTypeManager.java:107)
        at
org.apache.poi.openxml4j.opc.internal.ZipContentTypeManager.<init>(ZipContentTypeManager.java:56)
        at
org.apache.poi.openxml4j.opc.ZipPackage.getPartsImpl(ZipPackage.java:167)
        at
org.apache.poi.openxml4j.opc.OPCPackage.getParts(OPCPackage.java:662)
        at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:269)
        at org.apache.poi.util.PackageHelper.open(PackageHelper.java:39)

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message