how to check if an excel sheet is empty ?

[Anonymous]

Hello !
I have an excel file which contains several sheets and I need to create a new sheet in which I list the name of each sheet with a "OK" if the sheet is empty or "KO" if the sheet is not empty... Is it possible to do this with talend ?
tFileProperties doesn't let me manipulate sheets so I don't know how to see if my sheet is empty or not.
Thank you for your help !

[Anonymous]

Hello,
You could use some tJava and loading the jxl.jar library test what u need.
See http://jexcelapi.sourceforge.net/ for info about the API.

[Anonymous]

Thank you Morbo !
However I think I need a little more details to do that...

[_AnonymousUser]

Hello ,
how do you do to load the jxl.jar library.
I have the jxl.jar but I don't know how to load it .
Thx

[Anonymous]

Hi,
Use the "tLibraryLoad" component at the start of your job.
Best regards,
Nicolas

[Anonymous]

hi all,
or if you want to use it in our own routine , you have to right clic on it (routine) to "edit routine librairies" and add jar file !
++

[Anonymous]

Hi
And do you know if it's possible to export this jar (edit routine librairies) with a job export made with Command Line ? I tried and it's not made automatically... is it possible ? or not ? or just bugged ?