Subscribe Bookmark RSS Feed

check the value in last column of Excel sheet

Ashok

Community Member

Joined:

Nov 3, 2016

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

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson

Super User

Joined:

Jun 22, 2012

Solution

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;
Jim
1 REPLY
txnelson

Super User

Joined:

Jun 22, 2012

Solution

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;
Jim