[TypeConverterAttribute(typeof(StringTypeConverter))]
public class SheetRange : NumberRange
<TypeConverterAttribute(GetType(StringTypeConverter))>
Public Class SheetRange
Inherits NumberRange
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.
Creating a SheetRange instance:
var sheetRange = new SheetRange("1-5");
//Same as above, SheetRange1 can be implicitly converted from a string
SheetRange sheetRange2 = "1-5";
Dim sheetRange As New SheetRange("1-5")
'Same as above, SheetRange1 can be implicitly converted from a string
Dim sheetRange2 As SheetRange = "1-5"
SheetRange | Initializes a new instance of the SheetRange class from the specified string. |
Add(Int32) | Adds a single sheet number to the sequence. (Overrides NumberRangeAdd(Int32)) |
Add(String) | Adds a range of sheet numbers to the sequence from a string representation (e.g. 1-5, 8, 11-13). (Overrides NumberRangeAdd(String)) |
Add(NullableInt32, NullableInt32) | Adds a range of sheet numbers to the sequence. Reverse ordering is accepted. (Overrides NumberRangeAdd(NullableInt32, NullableInt32)) |
Contains |
Determines whether this instance contains the specified range part (number range or keyword).
(Inherited from NumberRange) |
Enumerate | Enumerates all the sheet numbers that this range instance describes. The sequence will be distinct and in ascending order. (Overrides NumberRangeEnumerate(Int32)) |
ExpandKeyword |
Expands a supported keyword to an enumerable sequence of numbers. It can be overriden in derived classed to support additional keywords.
(Inherited from NumberRange) |
MatchKeyword |
Matches a supported keyword. It can be overriden in derived classed to support additional keywords.
(Overrides NumberRangeMatchKeyword(String)) |
Parse | Converts a string containing the range of sheet numbers to a SheetRange. |
ToString | Converts this instance to a string containing the range of sheet numbers. (Overrides NumberRangeToString) |
(SheetRange to String) | Converts a SheetRange to a string containing the range of sheet numbers. |
(String to SheetRange) | Converts a string containing the range of sheet numbers to a SheetRange. |