| Author |
 Topic  |
|
|
Vilito
3 Posts |
 Posted - 05/15/2012 : 10:57:07 AM
|
Origin Ver. and Service Release: OriginPro 8.6 (32-bit) sr 1
Operating System: Win7 64bit
I am interested in make absorption measurements, to do that I need to make a simple operation( log(col(a)/col(b)), I am always taking col(a) as reference) this is really easy to do with few columns, the problem is that I have 2000 columns per workbook and 50 different workbooks. Is there anyway to make it?
It will be nice if I can put the generated data in a new workbook to make it more easy-to-use.
Thank you. |
|
|
Vilito
3 Posts |
Posted - 05/16/2012 : 09:01:54 AM
|
I've been looking on the help window and the only thing similar that I've found is the "Entering Expressions in the Set Column Dialog" topic. However, I haven't succeed. Any suggestions will be more than welcome.
Thank you
|
 |
|
|
greg
USA
1378 Posts |
Posted - 05/16/2012 : 3:53:53 PM
|
It isn't clear what you are trying to do, but you can use the csetvalue X-Function to programmatically do what Set Column Values does.
For example:
csetvalue
col:=3
formula:=log(col(1)/col(2))
script:=""
recalculate:=none;
Combine that information with this general loop through all columns in all Worksheets in all Workbooks:
// For all Workbooks
doc -e W
{
// For all Worksheets in current Workbook
loop(iWks,1,page.nlayers)
{
// Make next Sheet active
page.active = iWks;
// For all columns in the active Sheet
loop(iCol,1,wks.ncols)
{
ty %(page.name$), %(layer.name$), %(wks.col$(iCol).name$);
}
}
}
|
|
|
| |
Topic |
|
|
|
Set workbook values?