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
 Origin Forum
 Automatically access data from report sheet?		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Torracc

3 Posts
Posted - 07/22/2019 :  05:01:46 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hi Community,

I am working on a simple template for a linear fit. After analyzing the data I get two new sheets. The first one has this statistics about the fit. The second one has the data for the curve fitting. All I need is actually the data from the second sheet (slope, error LCL and UCL). Now I know that one can use something like "3!B" to access data from a different sheet. But how do I do this for the second sheet? I don't really now the origin of the data because I don't know the reference in the table. There must be a way to autoamtically access this fit data right?

I hope you can help me.

https://my.originlab.com/ftp/forum_and_kbase/Images/Origin_test.PNG

tl;dr: how can I find out the variable for the columns and rows in a report sheet so that I can use them as reference?
Edited by - Torracc on 07/22/2019 05:56:58 AM

Shirley_GZ

China
Posts
Posted - 07/22/2019 :  06:38:50 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Torracc,

If you want to access the result cells from script, please refer to this FAQ page,
https://www.originlab.com/doc/Quick-Help/Access-Result-Table-by-Script

If you want to use the result values in other sheet for further calculations, you can copy the cells and paste them as Link in other sheets. Or copy the whole table as a new sheet. For the details, please read this page
https://www.originlab.com/doc/Origin-Help/Analysis-Rep-Wks-Cols#Viewing.2C_editing_and_copying_report_tables

One more page, https://www.originlab.com/doc/Quick-Help/Copy-table

Thanks,
Shirley


Originlab Technical Service Team
Go to Top of Page

Torracc

3 Posts
Posted - 07/22/2019 :  08:11:58 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Shirley,

thank you for your quick reply.

So I want to script it I guess. The idea is to use a template, import the data, fit it linear and then use the slope to calculate some stuff. I tried it with the links you gave me but it appears I am to bad at scripting in origin.

So I got it to work by finding out what the "name" of the different values are (e.g. 2!Col(K)). And it works if I use it. But if I use it as a template it will kill the green refresh symbols and wont recalculate after importing even though the "name" of the results didn't change.

I am not quite sure how to use the script in a way that it works. I played around a little bit and did a combination of your two links, but I don't get it to work.

Before using the template:


after using the template:

using the scripts:
Edited by - Torracc on 07/22/2019 08:18:15 AM
Go to Top of Page

YimingChen

1613 Posts
Posted - 07/23/2019 :  11:46:12 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
You may want to copy the fitting parameters from result report sheet to a worksheet as a link.



James
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