4

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.

harish kumar
  • 45
  • 1
  • 8

1 Answers1

4

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

See here:

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.

bolav
  • 6,938
  • 2
  • 18
  • 42
  • Thanks for your comment. is there any way to skip the password protected file and read other files ? – harish kumar Dec 17 '15 at 09:49
  • I have a large number of excel files(number can change for every run) in input directory. How can excel input will read the password less files and skip protected files ? – harish kumar Dec 17 '15 at 10:21
  • As I said in the answer. Iterate over them and execute a job, that will execute a transformation for every XLS. – bolav Dec 17 '15 at 11:00
  • Thanks for answering. How can we implement the iteration over a excel file? Can you please help me with this ? – harish kumar Dec 17 '15 at 13:55
  • For instance: Have a transformation that runs Get File Names, and then run a ExcelRunner job. Then have the job run the transformation that reads the excel file. – bolav Dec 17 '15 at 15:00