2.2.3.30 wAppend

Menu Information

Worksheet:Append Worksheet

Brief Information

Append multiple worksheets into a single worksheet

Additional Information

Minimum Origin Version Required: 2015 SR0

Command Line Usage

  1. wAppend irng:=([Book1]Sheet1!, [Book1]Sheet2!, [Book2]Sheet1!) method:=row ow:=[<new>]<new>;

Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
Worksheets wks_list

Input

int

0

This variable is for internal use only and cannot be accessed from script.

Input irng

Input

Range

<unassigned>

This is used to specify the input worksheet range.

The syntax is: ([BookName]SheetName!, [BookName2]SheetName2!).

Append by method

Input

int

0

Specify the direction to append worksheets. Option list:

  • column:Column{0}
    The worksheets will be appended as new columns.
  • row:Row{1}
    The worksheets will be appended as new rows.
Output Worksheet ow

Output

Worksheet

<new>

Specify the output range, see syntax here.

Description

You can refer to the Origin Help page to see how to use this tool in a graphical interface.

Related X-Functions

wsplit, wsplit_book, merge_book