Skip to main content
Biswajit
Participant
August 7, 2014
Question

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

  • August 7, 2014
  • 1 reply
  • 1666 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
Inspiring
August 7, 2014

Do you have a sample code to share?


Regards,

Anit Kumar

Biswajit
BiswajitAuthor
Participant
August 8, 2014

<cftry>

<cfspreadsheet action="read"

  src="E:\FromD\Test Codes\POIUtility.cfc-master\examples\CFSI_CMRT3-01 (2).xlsx"

  name="SpreadsheetObj">

</cfspreadsheet>

<cfdump var="#SpreadsheetInfo(spreadsheetobj)#">

<cfcatch><cfdump var="#cfcatch#"></cfcatch>

</cftry><cfabort>