8.1.26 Worksheet

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

Worksheet

Remark

Hierarchy


Property

Name Brief Example
Columns Read-only property. Return the columns collection. Examples

Members

Name Brief Example
Copy Copy a block of data from the Worksheet on to the clipboard. Examples
Columns Access the Columns collection Examples
GetColumns Return the columns collection. Examples
GetData Get data from a specified worksheet Examples
DeleteCol Delete column Examples
DeleteRow Delete row Examples
ExportASCII Export data as ASCII Examples
GetBounds Get the minimum beginning and maximum ending row indices for the specified columns in this Worksheet. Examples
GetColFormats Gets the column formats of all the columns in the worksheet Examples
GetIndex Get the index of the worksheet Examples
GetLabelVisible Show or hide some labels on worksheet Examples
GetSelectedColumns Fill a vector with column indexes where column is completely or partially selected Examples
GetUserDefLabel Get the user defined label
InsertCol Insert an empty column in the worksheet with the given name and store the name in a string. If the given name already exists then increment it. The actual name created is returned by reference Examples
InsertRow Insert row in the worksheet Examples
MergeCells To merge cells Examples
SetColDesignations Set the column designations Examples
SetColFormats Sets the column formats in a worksheet Examples
SetData Set Data for worksheet Examples
SetLabelVisible Set the Label visible Examples
SetLowerBound Set the Lower bound for worksheet Examples
SetScript Worksheet script setting Examples
SetUpperBound Set the upper row display index of the Worksheet. Examples
SetUserDefLabel Set the user defined label
ShowCol Show the specific columns Examples
ShowLabels Show [Hide] column labels Examples


Datasheet 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