Name
|
Brief Description
|
colcopy
|
Copy columns with format & headers
|
colint
|
Set Sampling Interval (Implicit X) for selected Y columns
|
colmask
|
Mask a range of columns based on some condition
|
colmove
|
Move selected columns
|
colshowx
|
Show X column (extract Sampling Interval) for the selected Y column(s)
|
colswap
|
Swap the position of two selected columns
|
filltext
|
Fill the cell in the specified range with random letters
|
getresults
|
Get the result tree
|
insertArrow
|
Insert arrow
|
insertGraph
|
Insert a graph into a worksheet cell
|
insertImg
|
Insert images from files
|
insertNotes
|
Embed a Notes page into a worksheet cell
|
insertSparklines
|
Insert sparklines into worksheet cells
|
insertVar
|
Insert Variables into cells
|
merge_book
|
Merge the workbooks to a new workbook.
|
sparklines
|
Add thumbnail size plots of each Y column above the data
|
updateEmbedGraphs
|
Update the embedded Graphs in the worksheet.
|
updateSparklines
|
Add thumbnail size plots of each Y column above the data
|
w2xyz
|
Convert formatted data into XYZ form
|
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.
|
wcellformat
|
Format the selected cells
|
wcellmask
|
Set cell(s) mask in specified range
|
wcellsel
|
Select cell(s) with specified condition
|
wclear
|
Worksheet Clear
|
wcolwidth
|
Update the width of columns in worksheet
|
wcopy
|
Create a copy of the specified worksheet
|
wdeldup
|
Remove Duplicated Rows:Remove rows in a worksheet based on duplications in one column
|
wdelrows
|
Delete specified worksheet rows
|
wkeepdup
|
Hold Duplicated Rows: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
|
wmergexy
|
Copy XY data from one worksheet to another and merge mismatching X by inserting empty rows when needed
|
wmove_sheet
|
Move the specified worksheet to the destination workbook
|
wmvsn
|
Reset short names for all columns in worksheet
|
wpivot
|
Pivot Table: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
|
wreplace
|
Find and replace cell value in a worksheet
|
wrow2label
|
Set Label Value
|
wrowheight
|
Set row(s) height
|
wsort
|
Sort an entire worksheet or selected columns
|
wsplit_book
|
Split specific workbooks into multiple workbooks with single sheet
|
wtranspose
|
Transpose the active worksheet
|
wunstackcol
|
UnStack grouped data into multiple columns
|
wxt
|
Worksheet Extraction
|