2.2.3.70 wsplit_book

Menu Information

Restructure: Split Workbooks

Brief Information

Split workbook into multiple single-sheet workbooks

Command Line Usage

wsplit_book 1; // split all workbook in active folder

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
Split fld

Input

int

active
 Specify what workbooks are to be split

Option list:

  • active:Active Book
Split the active workbook
  • folder:All in Active Folder
Split all workbooks in the active folder
  • recursive:All in Active Folder (Recursive)
Split all workbooks in the active folder recursively
  • open:All in Active Folder (Open)
Split all opened workbooks in the active folder
  • project:All in Project
Split all workbooks in the project
Split Mode mode

Input

int

duplicate
 Specify the split mode

Option list:

  • duplicate:Duplicate
Create duplicated worksheets from the workbook
  • drag:Drag
Drag worksheets out of the workbook
Keep Source Workbook keep

Input

int

1
 Whether keep source workbook after split
Rename Book Name with Sheet Name rename

Input

int

1
 Whether rename the new book name using the sheet name extracted
Key String Search at match

Input

int

none
 Where to search the key string

Option list:

  • none:NONE
Do not search key string
  • wkblong:Workbook Long Name
Search the long name of workbooks
  • wkbshort:Workbook Short Name
Search the short name of workbooks
  • comments:Workbook Comments
Search the comments of workbooks
Key String(like:"?ook*") key

Input

string

<unassigned>
 Specify the key string used in searching

Description

Split specific workbooks into multiple workbooks with single sheet

English | Deutsch | 日本語