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.20 merge_book

Brief Information

Merge multiple workbooks

Command Line Usage

1. merge_book;

2. merge_book fld:=project keep:=0 single:=0;

3. merge_book match:=wkblong key:="book*" rename:=sname;

Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
Merge fld

Input

int

folder

The level in which the books will be merged.
Option list:

  • folder:All in Active Folder
    All books in the active folder will be merged.
  • recursive:All in Active Folder (Recursive)
    All books in the active folder(including recursive folder) will be merged.
  • open:All in Active Folder (Open)
    All opened books in the active folder will be merged.
  • project:All in Project
    All books in the project will be merged.
Keep Source Workbooks keep

Input

int

1

Whether to keep the source Workbooks.

Only Merge Default Workbook single

Input

int

1

Whether only merge the default first workbook, that is to say, if 1, only the books with single worksheet will be merged.

Key String Search at match

Input

int

none

Specified merge only matched worksheet. The match options is the following list.
Option list:

  • none:NONE
    No contondition
  • wkblong:Workbook Long Name
    Match the workbook long name
  • wkbshort:Workbook Short Name
    Match the workbook short name
  • comments:Workbook Comments
    Match the workbook comments
Key String(like:"?ook*") key

Input

string

The specified match key.

Rename Worksheet with rename

Input

int

lname

Specified the rename option
Option list:

  • lname:Workbook Long Name
    Use the original workbook long name as the new worksheet book
  • sname:Workbook Short Name
    Use the original workbook short name as the new generated worksheet book
  • wksname:Worksheet Name
    Use the original worksheet name as the new created worksheet name.
  • reset:Reset Worksheet
    Reset the worksheet name.
Output Worksheet owp

Output

WorksheetPage

<new>

Specified the output worksheet page.

See the syntax here.

Description

This function is used to merge the workbooks to a new workbook. Each workbook will convert to worksheet in the new worksheet page.

 

© OriginLab Corporation. All rights reserved.