Question
I tried to read an Excel book using Read from Sheet operation, but the following error occurred with "EXCEL0004E".
What is the cause and how can I fix it?
Processing of [excel_sheet(read from file/excel/sheet)] failed. Cause: [com.appresso.ds.dp.modules.adapter.excel.ooxml.api.zip.ZipEntryNotFoundException: entry with specified name did not exist in the zip file. name=xl/ workbook.xml]
Answer
Possible Cause
The specified Excel book may have a password.
Read from Sheet operation cannot specify a book with a read password.
How to solve
Remove the password and specify the Excel book again.
Supplementation
Please refer to the following page for other specification limitations of EXCEL connector.
Limitations of EXCEL category
https://www.hulft.com/help/en-us/HULFTSquare/Content/CN_MPP/CN_message/msg_Excel.htm#limitations
Comments
0 comments
Article is closed for comments.