28755_en-US

liliconcom

check the value in last column of Excel sheet

Hi,

I have an Excel file in which i want to check the last row's 3rd column value equals 0 if not delete the row.

Help me with script

 

Ashok

Re: check the value in last column of Excel sheet

Here is a script that will do what you want. 

Names Default To Here( 1 );

dt = Open( "path to excel file" );

dt << select where( As Column( Column(3) << get name ) == 0 );

dt << delete rows;