Page Comparison

Introduce originpro module. get/set between pandas DataFrame and Origin worksheet.

Introduce originpro module. Support passing data between pandas DataFrame and Origin worksheet.

OC supports calling Python functions. By default the py file should be placed in the same folder as the c/cpp or XF file, and the name of the py file has to be origin.py.
To change that, you need to

1. to change working directory

import pandas as pd
import originpro as op
wks=op.find_wsheet()
df = wks.to_df()

wks = op.new_wsheet( 'Test Category' )
wks.from_df( df )

pip install numpy;

Python.OCWD$;//OC Working Directory

2. to change file name(independent of 1)

Python.OCWF$;//OC Working Filename

ORG-21996

Labtalk LT to call python functions

Support calling Python functions from Labtalk script

LT supports calling Python functions. By default the py file should be placed in the User Files Folder with name labtalk.py. Call function with syntax

aa = py.myfunc(x,y)

We can also specify the file name, for example, signal_utils.py, then we can call the function by

aa = py.signal_utils.myfunc(x,y)

Also, you can change the default working directory and default file name by following command,

Python.LTWD$;//LT Working Directory
Python.LTWF$;//LT Working Filename

To call Python function in the attached py file in the project, use the py.@ syntax.

aa = py.@myfunc(x,y) //if there is a single attached py file
aa = py.@filename.myfunc(x,y) //if there are multiple attached py files, use filename

By default, when calling Python function in LabTalk and Column Formula, function argument is assumed to be list of float, and this can be controlled by system variable @PYFV (Default is 3).

Also, you can specify the argument and return type with function annotations.

def f2(a:float, b=1)->float:
    return a+b

An alternative to specify argument and return type is to use docstring, which is more important when function is used in column formula.

f = float
F = list of float
s = str
S = list of str
i = int

ORG-22239

Show Python print immediately

Python print() function now output result immediately when executed

Added a system variable @PYO to control if show Python print immediately for Embedded Python.

@PYO=1(default):immediate output
@PYO=0:output at the end

For example:

import PyOrigin as po
print('before')
po.LT_execute('typ hi')
print('after')

if @PYO=1, will output as

before
hi
after

if @PYO=0, will output as

hi
before
after

ORG-22158

Support running UTF-8 py file in Origin Python

Support running UTF-8 py file in Origin Python

ORG-22042

Add some basic functions under MatricLayer class in OriginExt and PyOrigin

Add some basic functions under MatricLayer class in OriginExt and PyOrigin: SetShape(), SetNumMats(), GetNumMats()

Added three function in OriginExt and PyOrigin under MatricLayer class:

SetShape(self, nRows, nCols, bKeepData=FALSE)

SetNumMats(self, nMats)

GetNumMats(self)

ORG-22012

Origin COM Improvements 2021

Added following function in COM, OriginExt and PyOrigin: OPY_CLASS(Page)* , LoadPage(const string& strPathName, int options = CREATE_VISIBLE_SAME);

Added following function in COM, OriginExt and PyOrigin.

OPY_CLASS(Page)* LoadPage(const string& strPathName, int options = CREATE_VISIBLE_SAME);

ORG-21990

Improve Using Origin from Outside Python

Added python package OrglabExt for COM calling

Added python package OrglabExt for COM calling

ORG-22282

Prevent Script Window GUI for Python

if use script window to run Python, it shows message box that recommend to use Python Console instead.

Show message box that recommend to use Python Console instead.

ORG-22300

Set column value with Python code

Added Python Function tab in Set Column Value dialog to define Python functions which can be called to set column values.

Add Python Function tab in Set Column Value dialog

Image Removed

ORG-22525

Python control of plot colormap and color list

Added Python control of plot colormap, color list, symbol type and size.

Control over plot colormap and color list.

plot.colormap="candy.oth"
plot.colormap="beach.pal"

For example:

import originpro as op

wks = op.find_sheet()
graph = op.new_graph(template='scatter')
layer = graph[0]
plot = layer.add_plot(wks, coly=1, colx=0)
layer.rescale()
plot.color = op.color_col(1,'n')
plot.colormap="fire"

Also, control the plot symbol type and size

plot.symbol_kind
plot.symbol_size

ORG-22518

Better handling of Date and Time columns

Added methods to originpro WSheet class to set Date and Time format columns:

Added methods to originpro WSheet class to set Date and Time format columns:

wks.as_date(col=0, format='yyyy-mm-dd')
wks.as_time(col=0, format='HH:mm:ss')

Where format is Origin date time format specifiers.

ORG-22049

Python Packages tool

Easy way to install Python Packages in Origin from Python Packages menu.

Python Packages dialog to install, upgrade and uninstall packages.

Menus to open the dialog:

1. In Origin main window, choose Conectivity: Python Packages…

2. In Code Builder, choose Tools: Python Packages…

We recommend restart Origin after the installation.

ORG-22430

originpro package update-able independently

originpro package can now be updated independent of origin releases using Python Packages Tool in Code Builder’s Tools menu.

originpro package can now be updated independent of origin releases using Python Packages Tool

ORG-22048

Support Intellisense for Python

Support Intellisense for Python coding in Code Builder.

Implemented features:

1. Auto complete when typing in editor, or when invoked via menu/hotkey. (Ctrl+L)

2. Go to definition on symbol under cursor. (F11, or context menu)

3. Find references on symbol under cursor. (Alt+Shift+F, or context menu)

4. Docstrings shown as a popup window when hover on a symbol.

5. Signature help window will be shown after typing '(' for function hint, prototype, parameters will be shown in this window

6. Show symbols in current file (Alt+M, or main menu)

New system variables:

1. @CI: Enable/disable code intellisense

2. @CIE: Show LSP error. e.g. when fails to find/run dependency

3. @CIS: Enable intellisense for script window. default=off

ORG-22193

OriginExt support for originpro -- project level

originpro module is available for external python to call Origin COM by OriginExt.

Use originpro in external python to call Origin COM by OriginExt.

ORG-22316

Python Improvement in Workbook template

1. Workbook template now detects if necessary Python packages are installed.

2. Support running Python script saved in a text object in workbook.

1. Added page property “page.tkey$“ for packages, for example, set page.tkey$ = "py:pandas";for a template, when open this template in Origin, will check if pandas python package is installed.

2. Support running python code in a button. for example. then there are python in a button named test, just need to run “run -pyb test“.

ORG-22471

Add Python based templates in New Workbook dialog

More Python based workbook templates are added. Hovering mouse over those templates tells if it’s Python sample

Provide some new templates in New Workbook dialog to show how to use Python in Origin.ORG-22606

LT Labtalk Accessing Cells from Another Book

Improve LabTalk accessing cells notation from another book.

• Support col(A) notation. E.g., =[book1]1!col(A)[1]

• Book Name support resolving string varaible. E.g., Fill A1 cell with “Book1”, the cell formula =[A1$]1!A1 can refer to A1 cell in the 1st sheet of Book1

• Support A0 notation. E.g., =[A1$]1!B0