Hello All:

I tried to read password protected excel file by using this line of code

<cfspreadsheet action="read" query="MyControlPanelQuery" src="D:/LocalDocuments/FileName.xlsx">

I gave me this error "

An error occurred while reading the Excel: org.apache.poi.EncryptedDocumentException: The supplied spreadsheet is protected, but no password was supplied
"

I got this kind of error because the FileName.xlsx is password protected

The thing is "<cfspreadsheet action="read"....> doesn't any attribute to read a password protected excel file.

Any advice please?

Thank you