8.1.3.5 DataObject::ExecuteFormula

It is recommended that you switch to the originpro package. PyOrigin is primarily for users who need to work with Origin version prior to 2021.


Description

Trigger the execution of Column/MatrixObject formula.

Syntax

ExecuteFormula(Begin = 0,End = -1,  C1 = -1,  C2 = -1)

Parameters

Begin
Begining row index (0 based), <0 indicate the first row; default is -1.
End
End row index (0 based), <0 indicate the last row; default is -1.
C1
Start col index (0 based), <0 indicate the first col; default is -1.
C2
End col index (0 based), <0 indicate the last col; default is -1.

Return

True on success and False on failure.

Examples

import PyOrigin
#Assume a worksheet is active
wks=PyOrigin.WorksheetPages('Book1').Layers(0)
Col=wks.Columns(0)
Col.SetFormula('ran()')
Col.ExecuteFormula()