Interface IXLNamedRanges

Namespace

SlapKit.Excel.Excel

Assembly

SlapKit.Excel.dll

public interface IXLNamedRanges : IEnumerable<IXLNamedRange>, IEnumerable

Inherited Members

IEnumerable<IXLNamedRange>.GetEnumerator()

Extension Methods

AttributeExtensions.GetMethod<T>(T, Expression<Action<T>>)

AttributeExtensions.GetMethod<T>(T, Expression<Func<T, object>>)

Methods

Add(string, IXLRange)

Adds a new named range.

IXLNamedRange Add(string rangeName, IXLRange range)

Parameters

rangeName string

Name of the range to add.

range IXLRange

The range to add.

Returns

IXLNamedRange

Add(string, IXLRange, string)

Adds a new named range.

IXLNamedRange Add(string rangeName, IXLRange range, string comment)

Parameters

rangeName string

Name of the ranges to add.

range IXLRange

The range to add.

comment string

The comment for the new named range.

Returns

IXLNamedRange

Add(string, IXLRanges)

Adds a new named range.

IXLNamedRange Add(string rangeName, IXLRanges ranges)

Parameters

rangeName string

Name of the range to add.

ranges IXLRanges

The ranges to add.

Returns

IXLNamedRange

Add(string, IXLRanges, string)

Adds a new named range.

IXLNamedRange Add(string rangeName, IXLRanges ranges, string comment)

Parameters

rangeName string

Name of the ranges to add.

ranges IXLRanges

The ranges to add.

comment string

The comment for the new named range.

Returns

IXLNamedRange

Add(string, string)

Adds a new named range.

IXLNamedRange Add(string rangeName, string rangeAddress)

Parameters

rangeName string

Name of the range to add.

rangeAddress string

The range address to add.

Returns

IXLNamedRange

Add(string, string, string)

Adds a new named range.

IXLNamedRange Add(string rangeName, string rangeAddress, string comment)

Parameters

rangeName string

Name of the ranges to add.

rangeAddress string

The range address to add.

comment string

The comment for the new named range.

Returns

IXLNamedRange

Contains(string)

bool Contains(string name)

Parameters

name string

Returns

bool

Delete(int)

Deletes the specified named range's index (not the cells).

void Delete(int rangeIndex)

Parameters

rangeIndex int

Index of the named range to delete.

Delete(string)

Deletes the specified named range (not the cells).

void Delete(string rangeName)

Parameters

rangeName string

Name of the range to delete.

DeleteAll()

Deletes all named ranges (not the cells).

void DeleteAll()

InvalidNamedRanges()

Returns a subset of named ranges that do have invalid references.

IEnumerable<IXLNamedRange> InvalidNamedRanges()

Returns

IEnumerable<IXLNamedRange>

NamedRange(string)

Gets the specified named range.

IXLNamedRange NamedRange(string rangeName)

Parameters

rangeName string

Name of the range.

Returns

IXLNamedRange

TryGetValue(string, out IXLNamedRange)

bool TryGetValue(string name, out IXLNamedRange range)

Parameters

name string

range IXLNamedRange

Returns

bool

ValidNamedRanges()

Returns a subset of named ranges that do not have invalid references.

IEnumerable<IXLNamedRange> ValidNamedRanges()

Returns

IEnumerable<IXLNamedRange>