BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
Ashok
Community Member

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

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

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;
Jim
0 Kudos
1 REPLY 1
txnelson
Super User

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