Forum Discussion

AnilKumar_9's avatar
AnilKumar_9
Occasional Contributor
5 years ago

Unable to read data from excel getting org.codehaus.groovy.control.MultipleCompilationErrorsExceptio

I am trying to read the data from excel.xslx file and i am facing multiple error could some one help in resolving the issue.   Error Mgs:    org.codehaus.groovy.control.MultipleCompilationError...
HimanshuTayal's avatar
HimanshuTayal
Community Hero
5 years ago

AnilKumar_9 

 

Have you placed the POI jars to ext folder if yes which version of POI jars you are using. I am using POI-3.12.

 

  • AnilKumar_9's avatar
    AnilKumar_9
    Occasional Contributor
    5 years ago

    HimanshuTayal Yeah i have placed POI jar in Ext folder and i am using 4.1.2 POI version. 

    • HimanshuTayal's avatar
      HimanshuTayal
      Community Hero
      5 years ago

      AnilKumar_9 : Add ooxml-schemas-1.4 in your ext folder.

      Hope it will resolve your issue

      • AnilKumar_9's avatar
        AnilKumar_9
        Occasional Contributor
        5 years ago

        HimanshuTayal 

         

        I have place suggested jar in ext folder and i am getting other error 

         

        org.apache.poi.poifs.filesystem.OfficeXmlFileException: The supplied data appears to be in the Office 2007+ XML. You are calling the part of POI that deals with OLE2 Office Documents. You need to call a different part of POI to process this data (eg XSSF instead of HSSF) error at line: 59