How to remove empty rows when importing excel in JMP

[#1]

Hi All,

I am importing an excel file to JMP. There are many empty rows in excel (I can not delete them manually as there are 10s of such excel files) and when I import them to JMP, I do not find any option to delete/remove/suppress these empty files. JMP do show option to suppress empty columns but nothing for empty rows (at least I couldn't find it).

I tried to put "Suppress Empty Rows( 1 )" in the code but obviously it did not work.  

Or is there any other way to delete/remove entire row in JSL, if all the columns values are missing for that row. It should work irrespective of number of columns or column type.

Any help ?

[#2]

Look into 

     Tables=>Missing Data Pattern

[#3]

I was not able to get the results using "Missing Data Pattern". Created a for loop on all the columns for missing values, which worked but  may not the best way to deal it.
Thanks for your suggestion.