Options to Copy/Duplicate/Extract

Worksheet_Options_to_Copy

-cp

Syntax: worksheet -cp

Copy selected data in the active worksheet to the Clipboard for plotting.
This is equivalent to clicking the Mini Toolbar button Copy for Plotting while worksheet data are selected. Then paste data to graph window as new plot by layer -pcp or layer -pcpu.

-d

Syntax: worksheet -d wksName

Duplicate the active workbook into a new workbook named wksName (new wks becomes active window).

If wksName is not specified, an enumerating name of the original workbook is used.

worksheet -d Test; //Duplicate the active workbook into a new workbook named ''Test''
                   //and activated it.

-da

Syntax: worksheet -da wksName

Duplicate the active workbook into a new workbook name wksName (original workbook remains active).

If wksName is not specified, an enumerating name of the original workbook is used.

-dr

Syntax: worksheet -dr wksName

Duplicate the active workbook into a new workbook name wksName and execute the Worksheet Script of the active worksheet.

If wksName is not specified, an enumerating name of the original workbook is used.

-qa

Syntax: worksheet -qa Select QueryString

Extract columns satisfied with specified SELECT SQL query and then put them to the active book. Note that it will overwrite the existing column if it is not emtyp.

Refer to this page for details of SELECT query.

//extract Y columns with LN containing "Value" from Sheet1 of Book1
wo -qa SELECT Column FROM [Book1]Sheet1! WHERE Column_LName LIKE "Value*" AND Column_Type = Y;

-qn; Extract columns satisfied with specified SQL query and put to a new book =

Syntax: worksheet -qn Select QueryString

Extract columns satisfied with specified SELECT SQL query and then put them to a new book. Refer to this page for details of SELECT query.

//extract all columns from current project
wo -qn SELECT Column From Project;
//extract columns from current folder whose LoneNmae includes string "type"
wo -qn SELECT Column FROM ACTIVEFOLDER WHERE Column_LName LIKE "*type*";

-tc

Syntax: worksheet -tc

Copy the activa worksheet as HTML/EMF table. See also this page.