How to read password protected excel input in pentaho?

Question

How to read data from a password protected excel sheet in pentaho excel input step? If we cant read data from password protected excel sheet, how can we skip the file and read only password less excel sheets in pentaho?

Please help me with this. Thanks in advance.

Answer 1

PDI cannot read Excel files that are password protected to open.

See here:

• http://forums.pentaho.com/showthread.php?56662-Excel-Input-with-password-protected-workbook
• http://jira.pentaho.com/browse/PDI-10939

The Excel step does not have a failed handler, so you cannot to this inside the transformation. You can however have a job call a transformation, and this transformation step in the job will fail if the Excel file fails. I would have a job that would call the Excel transformation for each file, and then have a failed and success handler in the job.