Hi Matthias,
> I would like to have the recalculated data in the same worksheet as before.
To output the extracted data in the new sheet in the same workbook, you can set the output destination by "iy:=" option like:wextract iy:=[Book1]1!col(A) settings.stAlias.Cols:=1 settings.stAlias.AliasNames:=A settings.stCondition.Condition:="A<0.5" settings.cols:="0|1" oy:=<new>!<new>;
To add the extracted columns in the source worksheet, you can put a script like:
wextract iy:=[Book1]1!col(A) settings.stAlias.Cols:=1 settings.stAlias.AliasNames:=A settings.stCondition.Condition:="A<0.5" settings.cols:="0|1" oy:=<new>!<new>;
sheetno=page.active; //Sheet number
copydata irng:=1!1:2 orng:=[Book1]Sheet1!<new>; //Copy data to original sheet
page.active=sheetno; //Go back to the extracted sheet
layer -d; //Remove extracted sheet
Hope this helps.
--Hideo Fujii
OriginLab
Worksheet query (recalculation)
Posted - 04/10/2018 : 11:59:30 AM
