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.
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;
}
}