OriginLab Corporation - Data Analysis and Graphing Software - 2D graphs, 3D graphs, Contour Plots, Statistical Charts, Data Exploration, Statistics, Curve Fitting, Signal Processing, and Peak Analysis                           
 

2.2.3.42 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!; // copy to another sheet in same book

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

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.
When creating new, make it hidden hidden

Input

int

0
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

1
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

1
Specify whether to keep the column formula. Checked (value=1) for keep and unchecked (value=0) for not.

Description

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

 

© OriginLab Corporation. All rights reserved.