The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Exporting Selected Graph Ponts to Worksheet

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: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
rmfleming Posted - 09/26/2006 : 11:32:09 AM
Origin Version (Select Help-->About Origin): 7.5
Operating System: XP

I have a repetitive task that is becoming tedious

I plot a family of curves that show peaks evolving.
I want a plot of a peak height as a function of a variable given by the curve number.
I use the data reader to read the peak height from each curve. I write that down & obtain a long list of heights.
I then open a new worksheet and type in the list of heights & plot that.

There has got to be a better way to do this. I can't see any way to export from the data reader or screen reader directly to a worksheet. I'm thinking of using the add-on Origin digitizer, but that seems like a kludge.

Any help?
1   L A T E S T    R E P L I E S    (Newest First)
Mike Buess Posted - 09/26/2006 : 11:55:21 AM
You can use the GetPts command and/or write a script to do what you want. Best approach depends on details like this...

1. Are all curves in the same graph window?
2. Are the peak position(s) the same for all curves?
3. Are the peak position(s) known in advance or do you need a peak peaking routine?
4. Probably other questions will arise when those are answered.

For example, the following LabTalk script assumes you want the height (Y-value) at the same index in all curves in the active graph window. The point index is chosen with the data selector tool. (double-click or press ENTER).

getpts 1; // open data selector to select a single point
// define macro that determines what to do after a point is selected
def EndToolBox {
if( getpts.count==0 ) return; // quit if no points were selected
%Z=""; layer -c; // get names of all curves
win -t D; // create worksheet window
loop(i,1,count) {
%A=%[%Z,#i]; // get curve name
%H_A[i]$=%A; // write curve name to first column of worksheet
%H_B[i]=%A[index]; // write curve height to second column
};
};

Mike Buess
Origin WebRing Member

Edited by - Mike Buess on 09/26/2006 3:33:46 PM

Edited by - Mike Buess on 09/26/2006 4:49:53 PM

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000