# 2.2.3.65 wselcol

## Brief Information

Select or hide columns in worksheet

Minimum Origin Version Required: Origin 2017 SR0

 1. wselcol colx:=c test:=<[<c[L]$=="Sensor*">]> end:=10; //Select the "Sensor" columns(with word "Sensor" in its column long name).  2. wselcol operation:=hide mode:=skip sel:=2 skip:=3 end:=10; //Hide every 2 columns and then skip next every next 3 columns.  ## Variables Display Name Variable Name I/O and Type Default Value Description Input Worksheet iw Input Worksheet <active> Specify the input worksheet. Default is the current active worksheet. Operation operation Input int 0 Specify how to deal with the desired columns: Option list: • Select • Hide Mode mode Input int 0 Specify the mode to select the desired columns Option list: • By Test Condition Select or hide desired columns by a user-specified conditional expression. • By Select N columns and Skip M columns Select N columns and skip M columns periodically. Variable to Represent Test Column colx Input string x Define a variable name to represent columns, which is used in the conditional expression (such as. x[U]$=="amp" )
Test Condition test

Input

string

<unassigned>
Enter conditional expression in the edit box used to extract columns. You can use predefined variable name(such as x) and column label row character. For example,
x[U]$=="amp*" && x[C]$=="reference"  //select the columns with long name equals "amp" and comments equals "reference"

The wildcards (* and ?) are allowed here. More details, please refer to the condition box in Worksheet Query.

N= sel

Input

int

1
Select every N columns. This option is available when the Mode is set to By Select N columns and Skip M columns.
M= skip

Input

int

1
Skip every M columns after selected N columns. This option is available when the Mode is set to By Select N columns and Skip M columns.
Start Column start

Input

int

1
Specify the starting column.
End Column end

Input

int

-1
Specify the End column.

## Description

This X-Function is used to select or hide desired columns before plotting or analyzing.

The Select dialog, which is similar but simpler, is also available.