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
|
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.
|
|
wstacksheets
|
In the active workbook, stack one or more columns common to multiple sheets by label, into one sheet with grouping.
|
|
wtranspose
|
Transpose the active worksheet.
|
Example
|
wunstackcol
|
Unstack grouped data into multiple columns.
|
|
wxt
|
Worksheet Extraction.
|
Example
|