# SpreadsheetReferenceSequence

Immutable syntax for an OpenXML-style sequence of spreadsheet references.

Class 

`OfficeIMO.Spreadsheet`

**Namespace**

`OfficeIMO.Spreadsheet`

**Assembly**

`OfficeIMO.Core`

**Source revision**

`ba882f6b0d07` with working tree changes

**Source**

[SpreadsheetReferenceSequence.cs:18](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Core/Spreadsheet/SpreadsheetReferenceSequence.cs#L18)

**Modifiers**

sealed

Immutable syntax for an OpenXML-style sequence of spreadsheet references. Separators are recognized only outside quoted worksheet names, so punctuation inside names is never treated as structure.

## Inheritance

- object
- SpreadsheetReferenceSequence

## Usage

Explore 2 API references to this type

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

### Returned or exposed by 1

- Method [SpreadsheetReferenceSequence.Parse](/api/core/officeimo-spreadsheet-spreadsheetreferencesequence/#method-parse-string-officeimo-spreadsheet-spreadsheetaddressdialect)

### Accepted by parameters 1

- Method [SpreadsheetReferenceSequence.TryParse](/api/core/officeimo-spreadsheet-spreadsheetreferencesequence/#method-tryparse-string-officeimo-spreadsheet-spreadsheetaddressdialect-officeimo-spreadsheet-spreadsheetreferencesequence) parameter `sequence`

Filter members 

Show inherited

## Methods

`public static SpreadsheetReferenceSequence Parse(string text, SpreadsheetAddressDialect dialect)` [#](#method-parse-string-officeimo-spreadsheet-spreadsheetaddressdialect)

[SpreadsheetReferenceSequence.cs:18](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Core/Spreadsheet/SpreadsheetReferenceSequence.cs#L18)

Parses a comma- or whitespace-delimited reference sequence.

Parameters

**text string required**

**dialect OfficeIMO.Spreadsheet.SpreadsheetAddressDialect required**

Returns

`SpreadsheetReferenceSequence`

`public static bool TryParse(string? text, SpreadsheetAddressDialect dialect, out SpreadsheetReferenceSequence? sequence)` [#](#method-tryparse-string-officeimo-spreadsheet-spreadsheetaddressdialect-officeimo-spreadsheet-spreadsheetreferencesequence)

[SpreadsheetReferenceSequence.cs:28](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Core/Spreadsheet/SpreadsheetReferenceSequence.cs#L28)

Attempts to parse a comma- or whitespace-delimited reference sequence.

Parameters

**text string? required**

**dialect OfficeIMO.Spreadsheet.SpreadsheetAddressDialect required**

**sequence OfficeIMO.Spreadsheet.SpreadsheetReferenceSequence? required**

Returns

`bool`

## Inherited Methods

`public virtual bool Equals(object? obj)` [#](#method-equals-object)

Inherited from object

Parameters

**obj object? required**

Returns

`bool`

`public virtual int GetHashCode()` [#](#method-gethashcode)

Inherited from object

Returns

`int`

`public Type GetType()` [#](#method-gettype)

Inherited from object

Returns

`Type`

`public virtual string? ToString()` [#](#method-tostring)

Inherited from object

Returns

`string?`

## Properties

`public IReadOnlyList<SpreadsheetRangeReference> References { get; }` [#](#property-references)

[SpreadsheetReferenceSequence.cs:14](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Core/Spreadsheet/SpreadsheetReferenceSequence.cs#L14)

Gets the parsed references in authored order.

<!-- PowerForge markdown artifact sha256:AC12B74BA0B1D918102DA21AE1E2B11F17B58F7CFB1A950F0131A13D1AA62FA5 -->
