Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Excel input:worksheet protected

  1. #1

    Default Excel input:worksheet protected

    Dear all,


    I have a excel in which there is workbook protection by using a password.

    i run my transformation on this excel file.

    when doing so.. an error is comming saying


    2009//02//26 15:32:26 - dummy transformation - Dispatching started for transformation [dummy transformation]
    2009//02//26 15:32:32 - Excel Input.0 - ERROR (version 3.0.3, build 569 from 2007//11//14 00:11:43) : Error processing row from Excel file [c:\ETLSolution\6\9\ExcelInput\_258_257_1_452_1.xls] : jxl.read.biff.PasswordException: The workbook protected
    2009//02//26 15:32:32 - dummy transformation - ERROR (veis password rsion 3.0.3, build 569 from 2007//11//14 00:11:43) : Errors detected!
    2009//02//26 15:32:33 - dummy transformation - Transformation detected 1 steps with errors!
    2009//02//26 15:32:33 - dummy transformation - Transformation is killing the other steps!


    pls give some information on how to over come this error..

    password protection is a must.

    regards,

    sarat kiran
    tcs

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Password protected workbooks are not supported for the moment (v3.1). I also don't recall the library we use has excel password support.

    Regards,
    Sven

  3. #3

    Red face

    The solution will be to create an unprotected workbook from your file
    and then you can load it in PDI.
    Samatar

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.