topic Re: how to check if an excel sheet is empty ? in Talend Studio

how to check if an excel sheet is empty ?

Anonymous — Sat, 16 Nov 2024 13:55:08 GMT

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 !

Re: how to check if an excel sheet is empty ?

Anonymous — Fri, 12 Jun 2009 14:50:41 GMT

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.

Re: how to check if an excel sheet is empty ?

Anonymous — Mon, 15 Jun 2009 09:22:15 GMT

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

Re: how to check if an excel sheet is empty ?

_AnonymousUser — Tue, 16 Jun 2009 09:39:53 GMT

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

Re: how to check if an excel sheet is empty ?

Anonymous — Tue, 16 Jun 2009 10:23:25 GMT

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

Re: how to check if an excel sheet is empty ?

Anonymous — Tue, 16 Jun 2009 15:13:39 GMT

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 !
++

Re: how to check if an excel sheet is empty ?

Anonymous — Tue, 16 Jun 2009 15:24:47 GMT

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 ?