Contents |
Create a copy of the specified worksheet
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!; // copy to another sheet in same book
4. wcopy o:=junk! c:=0; // copy structure and labels only, do not copy data
| Display Name | Variable Name | I/O and Type | Default Value | Description |
|---|---|---|---|---|
| Input Worksheet | iw |
Input Worksheet | | Specify worksheet to copy. |
| Output Worksheet | ow |
Output Worksheet | | Specify the destination of copied worksheet.
See the syntax here. |
| Copy Data(false will copy only structure and headings) | copydata |
Input int | | 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. |
| When creating new, make it hidden | hidden |
Input int | | Specify whether to create a hidden worksheet. Checked (value=1) for hidden and unchecked (value=0) for not. |
| When output not a new book, activate the output sheet | activate |
Input int | | Specify whether to active the new worksheet. Checked (value=1) for active and unchecked (value=0) for not. |
| Keep Column Formula etc ouput operations | keep |
Input int | | Specify whether to keep the column formula. Checked (value=1) for keep and unchecked (value=0) for not. |
Copy the data or only structure of one worksheet to another worksheet