8.1.7 Datasheet

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.


Name

Datasheet

Remark

The Datasheet class provides methods and properties common to Origin worksheet and matrix layers. The Datasheet class is derived from the Layer and OriginObject classes from which it inherits methods and properties.

Hierarchy


Property

Name Brief Example
Cols Get/Set the number of columns in the datasheet Examples
Rows Get/Set the number of rows in the datasheet Examples

Members

Name Brief Example
Cell Get the value at the location (Row, Col) in the Datasheet Examples
ClearData Clear worksheet of data and reduce number of rows (or optionally NOT reduce) Examples
FindCol Get the number of columns in active worksheet. Examples
GetColCount Get the number of columns in active worksheet. Examples
GetRowCount Get the number of rows in active worksheet. Examples
SetCell Set the numeric value of a cell in the DataSheet Examples
SetColCount Set the number of columns in the DataSheet Examples
SetRowCount Set the number of rows in the DataSheet Examples
TCell Get the string value of a cell in the DataSheet Examples
Transpose Transpose a Datasheet Examples


Layer Members

Name Brief Example
GetGraphObjects Return the graph objects collection. Examples
GetPage Get the parent Page object that contains the laye Examples
GraphObjects Get the graph object in graph layer Examples


OriginObject Members

Name Brief Example
Destroy Destroy the Origin object Examples
DoMethod Execute object LabTalk methods Examples
GetBinaryStorage Get a binary storage as a tree
GetComments Retrieve the comments from an object that supports Comments Examples
GetIndex Get the index of an object in a Collection Examples
GetLongName Get the long name of an object Examples
GetName Get the short name of an object Examples
GetNumProp Get object property via LabTalk property name Examples
GetShow Get the show status of an object Examples
GetStorageNames Get names of storage class objects
GetStrProp Get object property via LabTalk property name Examples
GetTheme Get the theme as treenode Examples
LT_execute Execute the Labtalk script code. Examples
SetComments Sets the comments with a text string to an object that supports Comments Examples
SetIndex Set the index of an object in a Collection Examples
SetLongName Set the long name of an object Examples
SetName Set the short name of an object Examples
SetNumProp Set object property via LabTalk property name Examples
SetShow Set the show status of an object Examples
SetStrProp Set object property via LabTalk property name Examples
SetTheme Set the theme as treenode


OriginBase Members

Name Brief Example
IsValid Check whether the instance is valid Examples