/
B4 - Join Worksheet

B4 - Join Worksheet

ORG-10719 

Sample OPJ to download to try:  B4 Folder of 92DemoOthers.opj

Append Worksheet

Worksheets can be joined side by side or by adding rows in Origin 2015. 


How to:

  • When a worksheet is active, select menu Worksheet: Append Worksheet

 

 

Join Worksheet by Matching Column

ORG-11419

The x-function, wjoinbycol,  enable joining worksheets by the matched column in Origin 2015. 

Detailed Documentation: Please refer the wjoinbycol help page

How to:

  1. When a worksheet is active, open the Script Window (from menu, Window: Script Window) if it is not already open.
  2. In the Script Window, enter script below and press Enter

    wjoinbycol -d

Join Worksheet by Matching Labels

ORG-11420

The x-function, wjoinbylabel,  enable joining worksheets by the matched label (worksheet headers)

Detailed Documentation: Please refer the wjoinbylabel help page

How to:

  1. When a worksheet is active, open the Script Window (from menu, Window: Script Window) if it is not already open.
  2. In the Script Window, enter script below and press Enter

    wjoinbylabel -d

 

Related content

C3 - Remove/Combine Duplicate Rows
C3 - Remove/Combine Duplicate Rows
More like this
2016 Worksheet
2016 Worksheet
More like this
Excel Import Improvements - Partial Import, Sheet selection in Theme file, and Reimport of Multiple Sheets
Excel Import Improvements - Partial Import, Sheet selection in Theme file, and Reimport of Multiple Sheets
More like this
Importing OPJ
Importing OPJ
More like this
Copy & Paste Formula, Label Rows
Copy & Paste Formula, Label Rows
More like this
C3 - Pivot Table with More than 1 Source for Column or Row
C3 - Pivot Table with More than 1 Source for Column or Row
More like this