5 Replies Latest reply on Aug 25, 2014 4:10 AM by shamCF

    cfspreadsheet : Issue while reading Excel sheet (xls/xlsx) created from Microsoft Office 2013

    Biswajit

      I am facing an Issue while reading Excel sheet (xls/xlsx) created from Microsoft Office 2013.

      Here is the error
      #1: An error occurred while reading the Excel: org.apache.poi.EncryptedDocumentException: The supplied spreadsheet seems to be an Encrypted .xlsx file. It must be decrypted before use by XSSF, it cannot be used by HSSF.

      #2: An error occurred while reading the Excel: org.apache.poi.hssf.record.RecordFormatException: Unknown encryption info 4.

      I tried with CF9 and CF10. Found same error on both versions.
      Also, I updated POI jar files with updated POI 3.10 but no luck.

      Followed these links :
      https://issues.apache.org/bugzilla/show_bug.cgi?id=56564
      https://issues.apache.org/bugzilla/show_bug.cgi?id=35897

      Any help will be appreciated. Tx