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>;

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
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.
Dataset Identifier id

Input

int

3

Specify the source dataset identifier type to show in the output worksheet. Option list:

  • none:None{0}
    Do not show source dataset identifier.
  • range:Range{1}
    Show the Range of source worksheet.
  • book:Book Name{2}
    Show the Name of source workbook.
  • sheet:Sheet Name{3}
    Show the Name of source worksheet.
  • index:Index{4}
    Show the Index of source worksheet, which is specified by Index.
Index index

Input

string

<auto>

Available when Dataset Identifier is Index. Specify the Index of source worksheet to show in output..

The syntax is: start:increment, e.g. 0:0.5(0, 0.5, 1, 1.5...), default is <auto>, which equals to 1:1.

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