2.2.3.40 wclear

Menu Information

Worksheet: Clear Worksheet

Clear worksheet cells

Minimum Origin Version Required: Origin 2017

Note:


wclear reduce:=0;
wclear reduce:=0 op:=1 msg:=0 r1:=3;

Display Name	Variable Name	I/O and Type	Default Value	Description
Worksheet to clear	w	Input/Output Worksheet	<active>	Specify worksheet to be cleared.
Reduce Row Size	reduce	Input int	1	Specify whether (1) or not (0) to reduce the dataset sizes to 0 and number of rows to minimal for sheet size.
Clear Operations	op	Input int	1	Specify whether or not show missing as blank.
Warning Message Box	msg	Input int	1	Specify whether to pop-up a warning message.
Start Row Number	r1	Input int	1	Specify the start row number, from which to the end, the data will be cleared.
Reset Hidden Rows	hidden	Input int	1	Specify whether to keep (0) existing hidden rows or reset (1) to reveal all rows.
Labels to clear	labels	Input string	<none>	Specify whether to clear the label rows. If yes, specify which label rows would be clear. Option include: <none>: Keep all label rows. 0: Clear all label rows. Column Label Row Characters: Clear the specified label rows. For example, set `labels:=LU`, then Long Name row and Units row would be cleared. “!” + Column Label Row Characters: Clear all label rows except for the specified rows. For example, set `label:=!LU`, then except for Long Name row and Units row, the other label rows would be cleared. Note: You can check the Column Label Row Characters here.