What is the easiest way of deleting every second row (2nd, 4th, 6th, etc.) in the active worksheet? A script would be preferred so I can include it into my 'File Size Reduction Script'.
void deleteRow()
{
Worksheet wks = Project.ActiveLayer();
if(NULL==wks)
return; // no active window, or not a worksheet
int rowNumber, rowCount, firstCol;
rowNumber = wks.GetNumCols(); //number of rows in aktive worksheet
rowCount = 3; // for every third "rowCount = 3" and so on
firstCol = 0; // the first row to delete
int jj = 0;
for( int ii = 1; ii <= ((rowNumber - firstCol + rowCount) / rowCount); ii++ )
{
wks.DeleteCol(firstCol + jj);
jj=jj+rowCount - 1;
}
}
Your code acatually deletes columns instead of the rows. It was a slight tweak of your code that enables me to delete rows now.
Thanks again.
void delrow() { Worksheet wks = Project.ActiveLayer(); if(NULL==wks) return; // no active window, or not a worksheet waitCursor wCur; // Bring up wait cursor to indicate computation in progress int rowNumber, rowCount, firstRow; rowNumber = wks.GetNumRows(); //number of rows in aktive worksheet rowCount = 2; // for every third "rowCount = 3" and so on firstRow = 1; // the first row to delete int jj = 0; for( int ii = 1; ii <= ((rowNumber - firstRow + rowCount) / rowCount); ii++ ) { wks.DeleteRow(firstRow + jj); jj=jj+rowCount - 1; } }
Delete Every Second Row
Posted - 09/03/2008 : 02:49:49 AM
