[TypeConverterAttribute(typeof(StringTypeConverter))]
public class SheetRange : NumberRange<TypeConverterAttribute(GetType(StringTypeConverter))>
Public Class SheetRange
Inherits NumberRangeThe 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. |