| T O P I C R E V I E W |
| razva |
Posted - 10/09/2005 : 6:33:18 PM
Origin Version (Select Help-->About Origin): 7.5 SR5
Operating System:XP Prof
I have a script which uses doc -e W for making some calculus on hundreds of datasheets. In every datasheet there is only one column created by the script which holds the results I am interested in.
I want to make a script to take this column from all the workseets and copy the data into a new worksheet. Additionally, I need that all the new columns into the new workseet will have labels with the name of the worksheet they have been copied from.
I need this as I think Origin will be able to handle better and faster a project with only one worksheet (with some hundred columns)than it handles the present project with 5 hundred datasets.
How should I do this?
Thank you for your help.
|
| 2 L A T E S T R E P L I E S (Newest First) |
| razva |
Posted - 10/11/2005 : 5:46:30 PM
great!
thank you Mike |
| Mike Buess |
Posted - 10/10/2005 : 08:08:00 AM
Set the number of the column you want in the first line (cc)...
cc=2; // col #
win -t D; // new wks
%W=%H; // save name
del col(2); // remove Y col
nn=1;
doc -e W {
// skip if %H=%W
if("%H"!="%W") {
nn++;
%W!wks.addCol();
%W!wks.col$(nn).label$=%H;
copy %(%H,cc) %(%W,nn);
win -cd %H; // close wks ??
};
};
win -a %W; // activate %W
wks.labels(); // show col labels;
Mike Buess
Origin WebRing Member
Edited by - Mike Buess on 10/10/2005 08:18:56 AM |
