how to check if an excel sheet is empty ?

One Star

how to check if an excel sheet is empty ?

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 ! Smiley Happy
One Star

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

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.
One Star

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

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

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

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
Highlighted
One Star

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

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

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

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

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

Hi Smiley Happy
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 ?

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog