| T O P I C R E V I E W |
| bego1908 |
Posted - 01/21/2014 : 09:18:20 AM
Hi,
I am trying to develop a script where I would need to delete some rows, namely, I need to delete a row every sixty.
I know the command
range bb = Col(2)[1:5]
mark -d bb
which is able to delete from row 1 to 5. But what I need is to delete 60*(i-1)+1 rows where i=1,...,10. I am trying to insert a kind of loop instead of [1:5] but it doesnt work. Does anybody know how to do that?
Thanks |
| 4 L A T E S T R E P L I E S (Newest First) |
| raleighhhp |
Posted - 02/02/2014 : 12:01:00 PM
I have tried Dr. Bobs's fix and it worked for me
|
| greg |
Posted - 01/22/2014 : 09:57:09 AM
This works in Origin 8:
range raY = 2;
row = 60;
for( row = 60, done = 0 ; done == 0 ; row+=59 )
{
mark -d raY -b row -e row;
if(row+59 > raY.GetSize()) done = 1;
}
deletes rows 60, 120, 180, etc. |
| bego1908 |
Posted - 01/22/2014 : 04:49:01 AM
Thank you Dr Bob,
I think that is the X-function that I need. I should write
wdelrows del:=1 skip:=59 start:=1
The problem is that I have Origin Lab 8 and that X-function is not supported. I would need a newer version.
Do you have any other suggestion?
Thanks again
Bego1908 |
| Drbobshepherd |
Posted - 01/21/2014 : 10:21:44 AM
bego19908,
In your script, try the X-function, wdelrows.
If you want to do this manually, try the Worksheet:Reduce Rows pull-down menu.
DrBob |
|
|
