30+
years serving the scientific and engineering community
Log In
Watch Videos
Try Origin for Free
Buy
English
日本語
Deutsch
Toggle navigation
Products
PRODUCTS
Origin
OriginPro
Origin Viewer
All products
Origin vs. OriginPro
What's new in latest version
Product literature
SHOWCASE
Applications
User Case Studies
Graph Gallery
Animation Gallery
3D Function Gallery
FEATURES
2D&3D Graphing
Peak Analysis
Curve Fitting
Statistics
Signal Processing
Key features by version
LICENSING OPTIONS
Node-locked(fixed seat)
Concurrent Network (Floating)
Dongle
Academic users
Student version
Commercial users
Government users
Non-Profit users
Why choose OriginLab
Who's using Origin
What users are saying
Published product reviews
Online Store
Get a quote/Ordering
Find a distributor
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
Purchase
New Orders
Renew Maintenance
Upgrade Origin
Contact Sales(US & Canada only)
Find a Distributor
Licensing Options
Node-locked(fixed seat)
Concurrent Network (Floating)
Dongle
Academic users
Student version
Commercial users
Government users
Non-Profit users
Why choose OriginLab
Purchasing FAQ
Support
SERVICES
Transfer Origin to new PC
License/Register Origin
Consulting
Training
Renew Maintenance
SUPPORT
Support FAQ
Help Center
Contact Support
Support Policy
DOWNLOADS
Service Releases
Origin Viewer
Orglab Module
Product Literature
Origin Trial
All downloads
VIDEOS
Installation and Licensing
Introduction to Origin
All video tutorials
DOCUMENTATION
User Guide
Tutorials
Python Programming
OriginC Programming
LabTalk Programming
All documentation
Communities
User Forum
User File Exchange
About Us
OriginLab Corp.
News & Events
Careers
Distributors
Contact Us
Contact Us
Log In
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
App Development
Code Builder
License
MOCA
Orglab
2.2.3 X-Functions for Worksheet
Name
Brief
Example
colcopy
Copy columns with format & headers.
coldesig
Set plot designation of columns
colint
Set Sampling Interval (Implicit X) for selected Y columns.
Example
colhide
Hide/Unhide the specified column(s)
colmask
Masking of cells based on conditions.
Example
colmove
Move selected columns.
Example
colreverse
Reorder a range of row in column(s).
colshowx
Show X column (extract Sampling Interval) for the selected Y column(s).
Example
colslideshow
View a slide show of all the graphs that depend on specified columns.
colsplit
Split column(s) into multiple columns by row index grouping.
colswap
Swap the position of two selected columns
Example
filltext
Fill the cell in the specified range with random letters.
getresults
Get the result tree.
insertArrow
Insert arrow.
Example
insertGraph
Insert a graph into a worksheet cell.
insertImg
Insert images from files.
insertNotes
Embed a Notes page into a worksheet cell.
Example
insertSparklines
Insert sparklines into worksheet cells.
insertVar
Insert Variables into cells.
merge_book
Merge the workbooks to a new workbook.
patternD
Set column value for the selected column with date/time patterned data.
Example
patternN
Set column value for the selected column with numeric patterned data.
Example
patternT
Set column value for the selected column with arbitrary string patterned data.
Example
sparklines
Add thumbnail size plots of each Y column above the data.
Example
updateEmbedGraphs
Update the embedded Graphs in the worksheet.
updateSparklines
Update sparklines.
w2vm
Create a virtual matrix from worksheet data.
w2xyz
Convert columns of data into XYZ form.
Example
wAppend
Append multiple worksheets into a single worksheet
wautofill
Worksheet selection auto fill.
wautosize
Resize the worksheet by the column maximal string length.
wcellcolor
Set cell(s) color to fill color or set the selected character font color to Font color.
Example
wcellformat
Format the selected cells.
Example
wcellgraph
Modify properties of embedded graphs in the worksheet.
Example
wcellmask
Set cell(s) mask in specified range.
Example
wcellsel
Select cell(s) with specified condition.
wclear
Clear Worksheet with no option to Undo.
wcolwidth
Update the width of columns in worksheet.
wcopy
Create a copy of the specified worksheet.
wdeldup
Remove rows in a worksheet based on duplications in one column.
Example
wdelrows
Delete worksheet rows
Example
wextract
Use LabTalk condition expression to mask or extract desired data from the active worksheet.
Example
wjoinbycol
Join multiple worksheets into a single worksheet by matching columns.
Example
wjoinbylabel
Join multiple worksheets into a single worksheet by matching label row.
wkeepdup
Hold rows in a worksheet based on duplications in one column.
wks_update_link_table
Update the contents in the worksheet to the linked table on graph.
Example
wks_to_wiki_table
Output Worksheet As Wiki Table
wmergexy
Copy XY data from one worksheet to another and merge mismatching X by inserting empty rows when needed.
Example
wmove_sheet
Move the specified worksheet to the destination workbook.
Example
wmvsn
Reset short names for all columns in worksheet.
Example
wpivot
Create a pivot table to visualize data summarization.
wproperties
Get or set the worksheet property through a tree from script.
wrcopy
Worksheet Range Copy with options to copy labels.
Example
wreducerows
Reduce worksheet rows by deleting or merging.
Example
wreducecols
Reduce worksheet columns by deleting or merging.
Example
wreplace
Find and replace cell value in a worksheet.
Example
wrow2label
Set Label Value.
wrowheight
Set row(s) height.
wrowhide
Hide or unhide selected rows
wselcol
Select/Hide columns.
wsort
Sort an entire worksheet or selected columns.
Example
wsplit
Split one worksheet's columns into multiple worksheets.
wsplit_book
Split specific workbooks into multiple workbooks with single sheet.
wstackcol
Stack data from multiple columns into one column with grouping.
wtranspose
Transpose the active worksheet.
Example
wunstackcol
Unstack grouped data into multiple columns.
wxt
Worksheet Extraction.
Example
Skip Navigation Links
All Books
X-Function
X-Function Reference
Data Manipulation
X-Functions for Worksheet
User Guide
Tutorials
Quick Help
Origin Help
X-Function
Origin C
LabTalk Programming
Python
Python (External)
Automation Server
LabVIEW VI
App Development
Code Builder
License
MOCA
Orglab
Programming
X-Function Programming Guide
X-Function Reference
X-Function Tutorials
Data Exploration
Data Manipulation
Database Access
Fitting
Graph Manipulation
Image
Import and Export
Mathematics
Miscellaneous
Plotting
Signal Processing
Spectroscopy
Statistics
Utilities
Vision
Function Details
Alphabetic List to X-Functions
X-Functions for Gridding
X-Functions for Matrix
X-Functions for Worksheet
addsheet
assays
clrAllData
copydata
cxt
findreplace
levelcrossing
m2v
map2c
mc2ap
mc2ri
mcopy
mks
mo2s
mri2c
ms2o
newbook
newsheet
rank
reduce_ex
reducedup
reducerows
reducexy
subtract_line
subtract_ref
text2cols
trimright
v2m
vap2c
vc2ap
vc2ri
vfind
vri2c
vshift
wxcat
xy_resample
xyz_resample
colcopy
coldesig
colhide
colint
coljoinbydesig
colmask
colmove
colreverse
colshowx
colslideshow
colsplit
colswap
filltext
getresults
insertArrow
insertCmt
insertGraph
insertImg
insertNotes
insertSparklines
insertVar
merge_book
patternD
patternN
patternT
sparklines
updateEmbedGraphs
updateSparklines
w2vm
w2xyz
wAppend
wautofill
wautosize
wcellcolor
wcellfmt
wcellformat
wcellgraph
wcellmask
wcellsel
wclear
wcolor
wcolordup
wcolwidth
wcopy
wdeldup
wdelrows
wextract
wheatmap
wjoinbycol
wjoinbylabel
wjoincols
wkeepdup
wks_to_wiki_table
wks_update_link_table
wmergexy
wmove_sheet
wmvsn
wpivot
wproperties
wrcopy
wreducecols
wreducerows
wreplace
wrow2label
wrowheight
wrowhide
wselcol
wsort
wsplit
wsplit_book
wstackcol
wstacksheets
wtranspose
wunstackcol
wxt
English
|
Deutsch
|
日本語
© OriginLab Corporation. All rights reserved.
×
☐
_
Let's Chat