• Font Size
  • S
  • M
  • L

Search via FAQ No.


  • No : 24416
  • Open Date : 2016/06/13 14:16
  • 更新日時 : 2020/10/07 10:20
  • Print

[DataSpider Servista] Error occurs when reading the Excel book with "Read from Sheet" icon

When tried to read the Excel book using "Read from Sheet" icon, the below error occurs. Explain the cause and the counter measure?
 
jxl.read.biff.PasswordException: jxl.read.biff.PasswordException: The workbook is password protected
Category : 

Answer

■Assumed causes
 
Password might be set for the specified Excel book. You cannot specify a book for which read password is set.
 
■Handling method
 
Cancel the password and specify the Excel book once again.
 
■Supplement
 
For details on the specification limitation other than the above mentioned one, check "Specification Limitation" of Product Help from "Reference Information".
 
・Read from Sheet
・Read from Named Range