30+
Jahre Hochleistungssoftware für Wissenschaft und Ingenieurwesen
Anmeldung
Watch Videos
Kostenlos testen
Kaufen
English
日本語
Deutsch
Toggle navigation
Produkte
PRODUKTE
Origin
OriginPro
Origin-Viewer
Alle Produkte
Origin vs. OriginPro
Neuerungen in der aktuellen Version
Produktliteratur
DEMONSTRATIONEN
Anwendungen
Anwenderberichte
Grafikgalerie
Animationsgalerie
3D-Funktionsgalerie
FUNKTIONEN
Grafische Darstellung in 2D und 3D
Peakanalyse
Kurvenanpassung
Statistik
Signalverarbeitung
Schlüsselfunktionen nach Version
LIZENZIERUNGSOPTIONEN
Node-Locked (rechnergebunden)
FLEXnet Concurrent (Netzwerk)
Dongle
Akademiker
Studentenversion
Anwender in der Industrie
Anwender in Behörden
Warum OriginLab?
Wer verwendet Origin?
Anwendermeinungen
Veröffentlichte Produktbewertungen
Online-Shop
Angebot anfragen/Bestellen
Vertriebspartner suchen
Apps
Data Import
CSV Connector
Excel Connector
MATLAB Connector
XML Connector
LeCroy Connector
Agilent MS
Tektronix WFM
Google Map
N42 Connector
More...
Graphing
Graph Maker
Paired Comparison Plot
Manhattan Plot
Forest Plot
Piper Diagram
Voronoi Diagram
Chromaticity Diagram
Heatmap with Dendrogram
More...
Publishing
Graph Publisher
Send Graphs to PowerPoint
Send Graphs to Word
Send Graphs to OneNote
Movie Creator
Graph Anim
More...
Curve Fitting
Simple Fit
Speedy Fit
Rank Models
Fit ODE
Neural Network Fitting
Fit Convolution
Polynomial Surface fit
Enzyme Kinetics
Drug Dissolution Analysis
More...
Peak Analysis
Simple Spectroscopy
Peak Deconvolution
Pulse Integration
Align Peaks
Global Peak Fit
PCA for Spectroscopy
2D Peak Analysis
Gel Molecular Weight Analyzer
More...
Statistics
Stats Advisor
PCA
DOE
Chi-Square Test
Weibull Fit
Structural Equation Modeling
Surface Roughness Parameters
More...
How do Apps work in Origin?
Suggest a New App
Kaufen
Neuaufträge
Softwarepflege verlängern
Upgrade für Origin
Vertrieb kontaktieren (nur USA & Kanada)
Vertriebspartner suchen
Lizenzierungsoptionen
Node-Locked (rechnergebunden)
FLEXnet Concurrent (Netzwerk)
Dongle
Akademiker
Studentenversion
Anwender in der Industrie
Anwender in Behörden
Warum OriginLab?
FAQ für Vertrieb
Support
SERVICE
Origin auf neuen PC übertragen
Origin lizenzieren/registrieren
Beratung
Schulung
SUPPORT
FAQ für Support
Hilfecenter
Support kontaktieren
Support-Richtlinien
DOWNLOADS
Service Releases
Origin Viewer
Orglab Module
Produktliteratur
Demoversion von Origin
Alle Downloads
VIDEOS
Installation und Lizenzierung
Einführung in Origin
Alle Video-Tutorials
DOKUMENTATION
Hilfe
Tutorials
Programmierung mit Python
Programmierung mit OriginC
Programmierung mit LabTalk
Gesamte Dokumentation
Communities
Anwenderforum
Anwenderdateiaustausch
Facebook
YouTube
LinkedIn
Über uns
OriginLab Corp.
Neuigkeiten & Events
Karriere
Vertriebspartner
Kontakt
Anmeldung
All Books
Non-Programming Books
User Guide
Tutorials
Quick Help
Origin Help
Programming Books
X-Function
Origin C
LabTalk Programming
Python
Python (External)
Automation Server
LabVIEW VI
Apps
App Development
Code Builder
License
MOCA
Orglab
3.5.8 Lookup and Reference
Lookup-Reference-Functions
Reference
Name
Brief
Example
Cell(r, c)
Gets or sets values in the active worksheet or matrix. Indicate the row number and column number in parentheses.
Example
Col(c)
Refers to the dataset in a worksheet column, to a cell in the column, or to the column headers.
Example
Wcol(x)
Can be used either on the left side or on the right side of an assignment.
Example
Lookup and Dataset Information
Name
Brief
Example
Category(dataset)
Returns a list of categories in a categorical column.
Example
Catindex(dataset)
Returns the category index for each element of a categorical column.
Example
Catrows(dataset)
Returns a pipe-separated list of all row indices by category for a categorical column.
Example
Cattext(n,dataset)
the
n
th category value of a categorical column.
Example
colnum
Returns the column position number of the column specified by colName.
Example
Errof(dataset)
Returns the dataset (error column) containing the error values of
dataset
.
Example
Findmasks(dataset)
Returns a dataset that contains the indexes of the masked data points.
Example
Firstpoint(dataset)
Return the first value of dataset.
Example
hasx(dataset)
Returns 1 if
dataset
is plotted against an X dataset in the active layer. If not, this function returns 0.
Example
Index
Returns the index of x in a strictly monotonic dataset.
Example
IsMasked(index, dataset)
Returns the number of masked points in
dataset
if
index
= 0.
Example
Lastpoint(dataset)
Return the last value of dataset.
Example
List(value, dataset)
Returns the index number in
dataset
where
value
first occurs.
Example
lookup(str$, vs, vref[, option, Case]), lookup(str$, vs, vref[, option, Case])$
Finds a string pattern
str
within a vector
vs
and returns a value with the same index in another vector
vref
.
Example
NameOf
Get the actual internal dataset name from a range string.
Plotdata(index, designation, rowNum, colNum)
Return the designated dataset of the index number plot at (rowNum, colNum) panel of the active layer
Example
Table(vd, vref, d[.option])
Table(vd, vref$, d[.option])
Searches a numeric value d in dataset vd and returns the value in vref whose index number is the same as d in vd.
Example
Unique(vs[, Sort, Occurrence, sort2)
Returns a vector of the unique values in
vs
.
Example
Xindex(x, dataset)
Returns the index number of the cell in the X dataset associated with
dataset
, where the cell value is closest to x.
Example
Xof(dataset)
Returns the X values of a named dataset or range.
Example
Xvalue(i, dataset)
Returns the corresponding X value for
dataset
at row number
i
in the active worksheet.
Example
Skip Navigation Links
All Books
LabTalk Programming
Language Reference
Function Reference
Lookup and Reference
User Guide
Tutorials
Quick Help
Origin Help
X-Function
Origin C
LabTalk Programming
Python
Python (External)
Automation Server
LabVIEW VI
Apps
App Development
Code Builder
License
MOCA
Orglab
Programmieren
Note For Upgrade Users
LabTalk Scripting Guide
Language Reference
Script Examples
Tutorials
System Variables
System Variable List
Command Reference
LabTalk-Supported Origin C Functions
Function Reference
Macro Reference
Object Reference
Others(LabTalk)
Reference Tables
Math and Trigonometry
Statistics
Distribution
Signal Processing
Data Generation
Datenbearbeitung
Text
Lookup and Reference
Date and Time
Logical
Engineering
Miscellaneous
Financial
Alphabetical Listing of Functions
Category
Catindex
Catrows
Cattext
Cell
Col
Colnum
Errof
FindMasks
Firstpoint
Hasx
Idx
IsMasked
Lookup
Lastpoint
List
NameOf
Plotdata
ReportCell
Table
Unique
WCol
Xindex
Xindex1
Xof
Xvalue
English
|
Deutsch
|
日本語
© OriginLab Corporation. Alle Rechte vorbehalten.
×
☐
_
Let's Chat