SheetRangeAdd(String) Method

Adds a range of sheet numbers to the sequence from a string representation (e.g. 1-5, 8, 11-13).

Definition

Namespace: GleamTech.DocumentUltimate
Assembly: GleamTech.DocumentUltimate (in GleamTech.DocumentUltimate.dll) Version: 7.2.0

C#

public override void Add(
	string sheetRangeString
)

VB

Public Overrides Sub Add ( 
	sheetRangeString As String
)

The range is specified as a string in the following forms or combination thereof:

5	single value
1,2,3,4,5	sequence of values
1-5	closed range
-5	open range (converted to a sequence from 1 to 5)
1-	open range (converted to a sequence from 1 to final sheet)
all	keyword representing all sheet numbers.
odd	keyword representing odd sheet numbers.
even	keyword representing even sheet numbers.
active	keyword representing the active sheet number.
visible	keyword representing visible sheet numbers.

The value delimiter can be either ',' or ';' and the range separator can be either '-' or ':'. Whitespace is permitted at any point in the input.

Any elements of the sequence that contain non-digit, non-whitespace, or non-separator characters or that are empty are ignored.