Log error if data is not in wrong format in excel file

[Ajinkya]

Hi All,
I am using excel input step to read excel data. I want to log error if data in a particular column in excel file is of wrong format.
For example, log error with line number, if string data in numerical field.
I am using pentaho 7.1 ce.
Please help.


Thanks
Ajinkya

[Sparkles]

1) Add line number
2) Try to convert String to int
3) Direct error to log output