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

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

      • HimanshuTayal's avatar
        HimanshuTayal
        Community Hero
        5 years ago

        AnilKumar_9  : 

         

        You need to check you file type :

         

        XSSF is used for xlsx type

        HSSF is used to xls type