2.2.3.67 wselcol

1 Brief Information
2 Additional Information
3 Command Line Usage
4 X-Function Execution Options
5 Variables
6 Description

Brief Information

Select or hide columns in worksheet

Additional Information

Minimum Origin Version Required: Origin 2017 SR0

Command Line Usage

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.

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
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.