2.1.7 Datasheet


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

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