Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Excel Input with password protected workbook

  1. #1
    Join Date
    Sep 2007
    Posts
    2

    Default Excel Input with password protected workbook

    What methods are available for passing a password to a password protected Excel file in order to read it? What is the best way to accomplish this using th Excel Input step?

    Thanks,
    sryan

  2. #2

    Default

    IF excel file is potected against modification, Excel input step sould do the trick

    Rgds

    Samatar

  3. #3
    Join Date
    Sep 2007
    Posts
    2

    Default

    Quote Originally Posted by shassan2 View Post
    IF excel file is potected against modification, Excel input step sould do the trick

    Rgds

    Samatar
    Sorry for the confusion... the cells are not protected (nor the sheet). It is the file that I cannot access (through the Excel Input step in Spoon). The Excel file requires a password to access. Without it the Excel Input step in Spoon can not read the file. I have the passwrod, but no means of passing it though Excel Input step. So I'm guessing that there is some expression (or other means) in Spoon for handling this.

    Thanks.

  4. #4

    Default

    Ok

    I created a request

    http://jira.pentaho.org/browse/PDI-183

    Feel free to corrected it.

    Rgds

    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.