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

merge_book

Contents

Brief Information

Merge the workbooks to a new workbook.

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.

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.