I was trying to set the column formula by the Wsheet member function set_lable(col, val, type) with type='O', but python console returns KeyError: 'O', which I believe means that the embedded python doesn't support setting the formula label by the key 'O'.
Is there any other way to set the column formula using embedded Python?
yes, set_label is calling SetLongName, SetUnit, SetComment, so only those or a user parameter row by name.
We will hookup something but for now, I am afraid you will need to use Labtalk. For example, assuming active worksheet with values in column A and you want to do A+1 in column B,
import originpro as op
wks = op.find_sheet()
wks.obj.LT_execute('col(B)[O]$=A+1')
Here obj is a backdoor to call lower level PyOrigin things.
Setting column formula using embedded Python
Posted - 12/25/2020 : 12:30:33 AM
