| T O P I C R E V I E W |
| Torracc |
Posted - 07/22/2019 : 05:01:46 AM
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? |
| 3 L A T E S T R E P L I E S (Newest First) |
| YimingChen |
Posted - 07/23/2019 : 11:46:12 AM
You may want to copy the fitting parameters from result report sheet to a worksheet as a link.
James |
| Torracc |
Posted - 07/22/2019 : 08:11:58 AM
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:
 |
| Shirley_GZ |
Posted - 07/22/2019 : 06:38:50 AM
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 |
|
|
