Category:Worksheet (OriginCOM)

From OriginLab Wiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 22:56, 3 December 2008 (edit)
Eparent (Talk | contribs)
(Method)
← Previous diff
Revision as of 15:22, 16 December 2008 (edit) (undo)
Uploader (Talk | contribs)

Next diff →
Line 1: Line 1:
 +
==Description== ==Description==
Line 26: Line 27:
|- |-
| [[OriginCOM:Worksheet-Copy|Copy]] | [[OriginCOM:Worksheet-Copy|Copy]]
-| Copy a block of data from the Worksheet on to the clipboard. +| Copy a block of data from the Worksheet on to the clipboard.
-| align="center"| [[OriginCOM:Worksheet-Copy#Examples|Examples]]+| align="center"| [[OriginCOM:Worksheet-Copy#Examples|Examples]]
|- |-
Line 47: Line 48:
| [[OriginCOM:Worksheet-GetData|GetData]] | [[OriginCOM:Worksheet-GetData|GetData]]
| Get a block of data, within the specified row and column range, from the Worksheet. | Get a block of data, within the specified row and column range, from the Worksheet.
-| align="center"| [[OriginCOM:Worksheet-GetData#Examples|Examples]]+| align="center"| [[OriginCOM:Worksheet-GetData#Examples|Examples]]
|- |-
Line 56: Line 57:
|- |-
| [[OriginCOM:Worksheet-Labels|Labels]] | [[OriginCOM:Worksheet-Labels|Labels]]
-| Construct worksheet label region using [[LabTalk:Column_Label_Row_Characters|Column Label Row Characters]].+| Construct worksheet label region using [[LabTalk:Column_Label_Row_Characters#Even_Sampling_Interval|Column Label Row Characters]].
-| align="center"| [[OriginCOM:Worksheet-Labels#Examples|Examples]]+| align="center"| [[OriginCOM:Worksheet-Labels#Examples|Examples]]
|- |-
Line 154: Line 155:
|- |-
| [[OriginCOM:Worksheet-UserDefLabel|UserDefLabel]] | [[OriginCOM:Worksheet-UserDefLabel|UserDefLabel]]
-| +| Get and Set the sheet Row Label for a User-Defined Label row.
-| +| align="center"| [[OriginCOM:Worksheet-UserDefLabel#Examples|Examples]]

Revision as of 15:22, 16 December 2008

Contents

Description

Hierarchy

Method

Name Brief Example
Activate
ClearData
Copy Copy a block of data from the Worksheet on to the clipboard. Examples
Destroy
Execute
GetBinaryStorageData
GetData Get a block of data, within the specified row and column range, from the Worksheet. Examples
GetMetaData
Labels Construct worksheet label region using Column Label Row Characters. Examples
NewDataRange Creating a DataRange object. Examples
SetBinaryStorageData
SetData Send 2D array to Origin. This method is the same as Application.PutWorksheet Examples
SetMetaData


Property

Name Brief Example
Application
BinaryStorageNames
Cols The Cols property is an integer value that holds the number of columns in the worksheet. Examples
Columns
DataObjectBases
Index
LabelVisible Examples
LongName
Name
Parent
Rows The Rows property is an integer value that holds the number of rows in the worksheet. Examples
Show
Theme
UserDefLabel Get and Set the sheet Row Label for a User-Defined Label row. Examples