Skip to main content
Biswajit
Biswajit
New Participant
August 7, 2014
Question

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

  • August 7, 2014
  • 1 reply
  • 1653 views

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

This topic has been closed for replies.

1 reply

Anit_Kumar
Community Manager
Anit_KumarCommunity Manager
Community Manager
August 7, 2014

Do you have a sample code to share?


Regards,

Anit Kumar

Biswajit
BiswajitAuthor
New Participant
August 8, 2014

Here is the excel file: dropbox.com/s/0879kn0da6aoqou/CFSI_CMRT3-01%20(2).xls

Anit_Kumar
Community Manager
Anit_KumarCommunity Manager
Community Manager
August 8, 2014

I can run the code with ColdFusion 9 and ColdFusion 10. Here's the Output tested with Excel created in 2013.

Can you test the sample code

Dropbox - testSpreadsheet.xlsx

Dropbox - cfspreadsheet_db.cfm

Regards,

Anit Kumar

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices