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
Go to 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;