Worksheet: Split Worksheet
Split worksheet by rows/columns or values in reference column
Minimum Origin Version Required: Origin 8.6. Split partial worksheet, split by Reference Columns and Preset Result Sheet Name require 2017b.
1. wsplit mode:=row row:=5;
2. wsplit mode:=label label:=L keep:=1;
3. wsplit mode:=ref ref:=[Book1]Sheet1!A name:=<[<%N_%V>]>;
Note that from Origin 2017, column Short Name is restricted to alphabetical order and it cannot be edited, by default. So the Keep Short Name option is hidden in the GUI (see note at the bottom of the page). The script user can output customized Short Names using sn:=1, regardless of the value of @SSG.
%N = ref name, LN if present, otherwise SN
%C = ref dataset name
%M = ref Comment
%U = ref Units
%V = ref cell values (grouping variable)
Variables can be used in combination and incorporate arbitrary text (e.g. %N=%V). Whether used singly, in combination or with arbitrary text, variables must be protected as in the following example:
wsplit mode:=ref ref:=[Book1]Sheet1!A name:=<[<%N_%V>]>;
This X-Function is used to split one worksheet's columns into multiple sheets, according to the method specified.