Hinweis：Dieser Abschnitt ist nur in englischer Sprache verfügbar. Wir bitten um Ihr Verständnis.

3.3.2.65 Worksheet

Brief Introduction

Use this command to set various formatting options for, and plot data from, the active worksheet.

worksheet  option argument

Option	Description
-a	Add n columns to the active worksheet
-c	Create a new Y column named colName and add it to the end of the worksheet
-f	Set the colRef column to the given Format
-fd	Set the number of decimal digits to be used by the colRef column
-fi	Set the colRef column's internal type to the specified value
-i	Insert the name column as the n+1 column in the worksheet
-n	Change the name of the colRef column to newName
-so D	Delete a worksheet column
-so I	Insert a worksheet column
-sou Y	Set column designation
-t	Set the colRef column as the given column type
-v	Verify that a named column exists

Option	Description
-cp	Copy selected data in the active worksheet to the Clipboard for plotting
-d	Duplicate the active workbook into a new workbook named wksName and new wks becomes active
-da	Duplicate the active workbook into a new workbook named wksName while original workbook remains active
-dr	Duplicate the active workbook into a new workbook and execute the Worksheet Script of the active worksheet
-qa	Extract columns satisfied with specified SQL query and put to active book
-qn	Extract columns satisfied with specified SQL query and put to a new book
-tc	Copy the active worksheet as HTML/EMF table

Option	Description
-k	Skip n header lines when importing ASCII data
-kl	Store a maximum of n lines of header information in column labels when importing ASCII data

Option	Description
-p	Plot the current worksheet selection in the nth graph type into the template
-pa	Plot data in current workbook/worksheet into the specified cloneable template
-pc	Plot data by specifying the start column and increment in the current worksheet
-pl	Replot the same plot type of the last plot

Option	Description
-b	Get the first workbook that begins with winName
-cdf	Clean up range style and name range format settings in active worksheet
-cof	Convert non-SCN column formula into SCN in active worksheet
-crr	Clear old banded row format in table
-e	Open the specified worksheet dialogbox
-es	Reset worksheet range selection behavior when selection fails
-fm	Report sheet's footer width setting
-fp	Toggle frozen panes on or off
-frd	Fix duplicates in the active sheet
-gd pb	Custom Page Breaks
-q	View Page Breaks
-r	Run the script in the Worksheet Script dialog box
-rf	Repair Set Values formula for the worksheet column
-rr	Recover the range with empty UID data reference
-rri	Recover the range with empty UID data reference and inputs
-s	Set the specified range to be the current worksheet selection
-scf	Clear cell formats of the selected range
-shdf	Create or modify a Shared Data Filter
-shdfd	Dump Shared Data Filters In Worksheet
-sl	Select label row cell range
-sou db	Delete rows before the selected row
-sou extend	Extend current selection to the bottom of the column
-sou mr	Move selected rows(s) up or down n rows
-clr	Clear all data and formatting from the active worksheet