2.2.3.44 wcopy

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.

Description

Copy the data or only structure of one worksheet to another worksheet