wxt

Contents

1 Brief Information
2 Command Line Usage
3 Variables
4 Examples

Brief Information

Worksheet Extraction

Command Line Usage

1. wxt test:="mod(col(c),2)=1" ow:=<new>;

2. wxt test:="col(1)<5" sel:=1;

Variables

Display Name	Variable Name	I/O and Type	Default Value	Description
Test Condition	test	Input string		Specified the test condition string.
Worksheet to Extract	iw	Input Worksheet	<active>	Specified the input worksheet.
Column From	c1	Input int	1	Specified the beginning column of the range to perform the extraction.
Column To	c2	Input int	-1	Specified the end column of the range to perform the extraction.
Row From	r1	Input int	1	Specified the beginning column of the range to perform the extraction.
Row To	r2	Input int	-1	Specified the end column of the range to perform the extraction.
Mark past Cells	sel	Input int	0	Specify the way to mark the past rows (rows that meet the test condition). Option list: none:None Don?t select or mark the past rows. sel:Select Cells Select/highlight the past rows. mask:Mask Cells Mask the past rows.
Extracted	ow	Output Worksheet	<optional>	Specify the worksheet for output. See the syntax here.
On Off for Pass	val	Output vector	<optional>	The X-Function can output a vector to indicate whether the condition is satisfied for each row in the input worksheet: 1 for true and 0 for false. For example, if this vector has two elements, 1 and 0, it will mean that the first row in the input worksheet satisfies the test condition while the second row does not. You can specify this vector with the val variable.
Indices of Pass	pass	Output vector	<optional>	Specify a vector which will hold the indices of the past rows.
Number of rows that passes	num	Output int	<optional>	Specify the output for the number of the past rows.

Examples

For more examples, please refer to XF Script Dialog (press F11).