SheetRange.Add Method

Definition

Adds a single sheet number to the sequence.

public override void Add(int singleSheet)

Adds a range of sheet numbers to the sequence. Reverse ordering is accepted.

public override void Add(int? startSheet, int? endSheet)

startSheet int?: The start sheet number of the range. If value is null, range is considered an open range from 1 to endSheet.
endSheet int?: The end sheet number of the range. If value is null, range is considered an open range from startSheet to final sheet.

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

public override void Add(string sheetRangeString)

sheetRangeString string: The string containing the range of sheet numbers.

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.