2.2.3.44 wcopy

1 Brief Information
2 Command Line Usage
3 X-Function Execution Options
4 Variables
5 Description

Brief Information

Create a copy of the specified worksheet

Command Line Usage

1. wcopy <active> [abc]efg!; // to a new book or existing book sheet with given names

2. wcopy 2! 3!; // copy by sheet index, 3rd sheet if not exsted will be created

3. wcopy o:=junk! rowselected:=1; // copy the selected data rows to another sheet in same book

4. wcopy o:=junk! c:=0; // copy structure and labels only, do not copy data

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

Display Name	Variable Name	I/O and Type	Default Value	Description
Input Worksheet	iw	Input Worksheet	<active>	Specify worksheet to copy
Output Worksheet	ow	Output Worksheet	<new>	Specify the destination of copied worksheet. See the syntax here.
Copy Data(false will copy only structure and headings)	copydata	Input int	1	Specify whether to copy data or not. Checked (value=1) will copy the data in source worksheet, and unchecked (value=0) will only copy the structure and headings of the source worksheet.
Copy Rows	rowselected	Input int	all	Specify the type of rows to copy. Option list all:All Rows All Rows in worksheet sel:Selected Rows Selected Rows in worksheet count:Random Rows by Count Random extraction of a certain number of rows from worksheet rate:Random Rows by Rate Random extraction of a certain rate of rows from worksheet
Count	count	Input int	16	Specify the number of rows to randomly extract from worksheet.
Rate	rate	Input double	0.5	Specify the rate of rows to randomly extract from worksheet.
Copy Worksheet Script	script	Input int	1	Specify whether to copy the worksheet script with the copied data.
When creating new, make it hidden	hidden	Input int	0	Specify whether to create a hidden worksheet to store the copied data. Checked (value=1) for hidden and unchecked (value=0) for not.
When output not a new book, activate the output sheet	activate	Input int	1	Specify whether to active the output worksheet if this worksheet is not a new one. Checked (value=1) for active and unchecked (value=0) for not.
Keep Column Formula etc. output operations	keep	Input int	1	Specify whether to keep the column formula etc. output operations. Checked (value=1) for keep and unchecked (value=0) for not.