verify if an excel file is empty in JSL

dghidoni2

hello

I have an issue: the data I'm feeding to a JSL script comes from an application which sometimes, when has no data to give, returns an empty excel file.

Is there any way to identify this empty table?

If i try to open it, jmp throws out an error and stops the script.

the funcion "is empty" works on open data table and applying it directly on the file give always the same result, regardless if the file is empty or not.

any suggestion?

thanks

ms

To avoid stopping of the script you can enclose the open() within a try() statement. To identify an empty Excel table you can try something like this:

If( Is Missing( Try( dt = Open( "/path/file.xls" ) ) ),

  Show( "NOOO!, Excel table is empty" ); //...jsl code if empty

,

  Show( "Carry on!" ); //...jsl code if file contains data

);