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
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum for Programming
 LabTalk Forum
 Read a report data		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Tryphon

36 Posts
Posted - 09/10/2016 :  1:40:46 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hello,

I desire to read data in a report data generated by this code :

win -a MyWKS; /* worksheet of my data */
tree twowayGUI;
xop execute:=init classname:=ANOVATwoWayRM iotrgui:=twowayGUI;
twowayGUI.GUI.InputData.Use = 0;
xop execute:=update iotrgui:=twowayGUI;
twowayGUI.GUI.InputData.Factor0$=Col(Time);
twowayGUI.GUI.InputData.Factor1$=Col(Species);
twowayGUI.GUI.InputData.Data$=Col(Data);
twowayGUI.GUI.InputData.Subject$=Col(Identities);
twowayGUI.GUI.Interactions=1;
twowayGUI.GUI.MeansComp.Bonferroni=1;
xop execute:=report iotrgui:=twowayGUI;
page.active=page.nlayers;

This generates a report in a separate sheet including multiple tables.

How to access a table, a column or a cell using a labtalk command ? I want to collect the results and use them in the remaining code of my macro.

Thank you.

Origin 2015 64 bits sr2
Operating System: Windows 8.1 64 bits

yuki_wu

896 Posts
Posted - 09/11/2016 :  10:38:51 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

I think you can access your report into a tree variable by using the getresults X-Function.

You can find the way in this example:
http://www.originlab.com/doc/LabTalk/guide/Accessing-Metadata#Access_Report_Page_Tree

Hope it helps.

Regards,
Yuki
OriginLab
Edited by - yuki_wu on 09/12/2016 9:18:22 PM
Go to Top of Page

Tryphon

36 Posts
Posted - 09/14/2016 :  07:32:54 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thank you, getresults is easy to use.
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000