The Origin Forum

The Origin Forum

All Forums

Origin Forum

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Format Mode:

Format:

Message:

* HTML is OFF
* Forum Code is ON

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
Fanning	Posted - 04/10/2014 : 04:48:14 AM Dear all, I have a large data sets, for each one the first 500 rows are just noise. At the moment, I am deleting them manually, but if anyone can help me to write a script, that would be much appreciated. Thank you very much in advance! Regards Fanning
4 L A T E S T R E P L I E S (Newest First)
Fanning	Posted - 04/11/2014 : 06:29:28 AM Thanks Greg. it works like a treat!
greg	Posted - 04/10/2014 : 10:01:22 AM This line: range aa = 1[1]:$(wks.ncols)[500]; includes column 1 [row 1] to "last column" [row 500]
Fanning	Posted - 04/10/2014 : 06:22:21 AM Dear Sean Thank you very much for your quick reply. It works exactly as you said! can I ask for one more favor: is it possible to omit the range of column step? my data sets have different column numbers, would be nice if i can process the data regardlessly. Thanks again Fanning
SeanMao	Posted - 04/10/2014 : 05:58:11 AM Hi Fanning, I wrote a simple code below which might serve your purpose: doc -ef W { doc -e LW { range aa =1[1]:4[500]; del aa; } } //It will loop over all worksheets in all workbooks and delete first 500 rows from column 1 to column 4. Regards! Sean OriginLab Tech Service

The Origin Forum