nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

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;

All comments

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;

Quick Links