Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
T O P I C R E V I E W
ticofiz
Posted - 10/31/2011 : 4:14:22 PM OriginPro 8.5.1 Windows 7 Ultimate 64 bit
Hello,
I am using this command line "loop(ii,1,wks.ncols) {smooth iy:=$(ii) meth:=sg npts:=5 poly:=2;};" to smooth data from a active workbook. Could you tell me please how can I apply this command on all the sheets from a workbook? The sheets have different names.
Thank you
3 L A T E S T R E P L I E S (Newest First)
karlhammer48
Posted - 11/14/2011 : 7:52:06 PM Cased solved thanks to you Penn
loop(jj, 1, page.nLayers) // loop over all worksheet in the active workbook
{
page.active = jj; // activate the jjth worksheet
loop(ii,1,wks.ncols)
{
smooth iy:=$(ii) meth:=sg npts:=5 poly:=2;
}
}
loop(jj, 1, page.nLayers) // loop over all worksheet in the active workbook
{
page.active = jj; // activate the jjth worksheet
loop(ii,1,wks.ncols)
{
smooth iy:=$(ii) meth:=sg npts:=5 poly:=2;
}
}