3.3.2.65.2 Options to Copy/Duplicate/Extract

-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.

-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.

-dos

Syntax: worksheet -dos

Open the to duplicate this report for special sheets

-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.

-lk

Syntax: worksheet -lk n count colName

Copy count column(s) from colName and paste it as to the nth columnin the active worksheet.

colName is the source column path, n is the column index to insert and count is the number of columns to be mirrored starting at the specified source column. n = 0 to add mirror as new column.

Use -lku to support undo.

//paste [book1]sheet2!col(B) and col(C) as mirror column to active sheet, [Book2]Sheet1!, start from col(A)
work -lki 1 2 [book1]sheet2!col(B); //a new column is inserted and col(B) and col(C) are pasted as mirrors
work -lk 1 2 [book1]sheet2!col(B); //no new column is added, col(B) and col(C) are pasted as mirrors to existed columns

-lki

Syntax: worksheet -lki n count colName

Copy count column(s) from colName and insert it as to the nth columnin the active worksheet.

colName is the source column path, n is the column index to insert and count is the number of columns to be mirrored starting at the specified source column.

Use -lkui to support undo.

//to paste [book1]sheet2!col(B) as mirror column to col(B) in active sheet, [Book2]Sheet1!,
work -lki 2 1 [book1]sheet2!col(B)

-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 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 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 .