3.3.2.65 Worksheet
Brief Introduction
Use this command to set various formatting options for, and plot data from, the active worksheet.
Syntax:
worksheet option argument
Options:
Options for Column
| Option
|
Description
|
|
|
Add n columns to the active worksheet
|
|
|
Create a new Y column named colName and add it to the end of the worksheet
|
|
|
Set the colRef column to the given Format
|
|
|
Set the number of decimal digits to be used by the colRef column
|
|
|
Set the colRef column's internal type to the specified value
|
|
|
Insert the name column as the n+1 column in the worksheet
|
|
|
Change the name of the colRef column to newName
|
|
|
Delete a worksheet column
|
|
|
Insert a worksheet column
|
|
|
Set column designation
|
|
|
Set the colRef column as the given column type
|
|
|
Verify that a named column exists
|
Options to Copy/Duplicate/Extract
| Option
|
Description
|
|
|
Copy selected data in the active worksheet to the Clipboard for plotting
|
|
|
Duplicate the active workbook into a new workbook named wksName and new wks becomes active
|
|
|
Duplicate the active workbook into a new workbook named wksName while original workbook remains active
|
|
|
Open the dialog to duplicate this report for special sheets
|
|
|
Duplicate the active workbook into a new workbook and execute the Worksheet Script of the active worksheet
|
|
|
Copy number of specified column(s) and paste it as to the active worksheet.
|
|
|
Copy number of specified column(s) and insert it as to the active worksheet.
|
|
|
Extract columns satisfied with specified SQL query and put to active book
|
|
|
Extract columns satisfied with specified SQL query and put to a new book
|
|
|
Copy the active worksheet as HTML/EMF table
|
Options for Import
| Option
|
Description
|
|
|
Skip n header lines when importing ASCII data
|
|
|
Store a maximum of n lines of header information in column labels when importing ASCII data
|
Options for Plot
| Option
|
Description
|
|
|
Plot the current worksheet selection in the nth graph type into the template
|
|
|
Plot data in current workbook/worksheet into the specified cloneable template
|
|
|
Plot data by specifying the start column and increment in the current worksheet
|
|
|
Replot the same plot type of the last plot
|
| -psd
|
Plot "Summary Stats" data in a Data Table. E.g.
work -psd 201;
|
Other Options
| Option
|
Description
|
|
|
Get the first workbook that begins with winName
|
|
|
Clean up range style and name range format settings in active worksheet
|
|
|
Convert non-SCN column formula into SCN in active worksheet
|
|
|
Clear old banded row format in table
|
|
|
Open the specified worksheet dialogbox
|
|
|
Reset worksheet range selection behavior when selection fails
|
|
|
Report sheet's footer width setting
|
|
|
Toggle frozen panes on or off
|
|
|
Fix duplicates in the active sheet
|
|
|
Custom Page Breaks
|
|
|
Activate the source column of the selected mirror column
|
|
|
View Page Breaks
|
|
|
Run the script in the Worksheet Script dialog box
|
|
|
Repair Set Values formula for the worksheet column
|
|
|
Recover the range with empty UID data reference
|
|
|
Recover the range with empty UID data reference and inputs
|
|
|
Set the specified range to be the current worksheet selection
|
|
|
Clear cell formats of the selected range
|
|
|
Create or modify a Shared Data Filter
|
|
|
Dump Shared Data Filters In Worksheet
|
|
|
Select label row cell range
|
|
|
Delete rows before the selected row
|
|
|
Extend current selection to the bottom of the column
|
|
|
Move selected rows(s) up or down n rows
|
|
|
Clear all data and formatting from the active worksheet
|
See Also:
{, } (command),
(object),
,
,
,
,
,