Class ExcelTableCollection

Namespace

OfficeOpenXml.Table

Assembly

EPPlus.dll

A collection of table objects

public class ExcelTableCollection : IEnumerable<ExcelTable>, IEnumerable

Inheritance

object

ExcelTableCollection

Implements

IEnumerable<ExcelTable>

IEnumerable

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Properties

Count

Number of items in the collection

public int Count { get; }

Property Value

int

this[int]

The table Index. Base 0.

public ExcelTable this[int Index] { get; }

Parameters

Index int

Property Value

ExcelTable

this[string]

Indexer

public ExcelTable this[string Name] { get; }

Parameters

Name string

The name of the table

Property Value

ExcelTable

The table. Null if the table name is not found in the collection

Methods

Add(ExcelAddressBase, string)

Create a table on the supplied range

public ExcelTable Add(ExcelAddressBase Range, string Name)

Parameters

Range ExcelAddressBase

The range address including header and total row

Name string

The name of the table. Must be unique

Returns

ExcelTable

The table object

Delete(ExcelTable, bool)

Delete the table

public void Delete(ExcelTable Table, bool ClearRange = false)

Parameters

Table ExcelTable

The table object

ClearRange bool

Clear the table range

Delete(int, bool)

Delete the table at the specified index

public void Delete(int Index, bool ClearRange = false)

Parameters

Index int

The index

ClearRange bool

Clear the rage if set to true

Delete(string, bool)

Delete the table with the specified name

public void Delete(string Name, bool ClearRange = false)

Parameters

Name string

The name of the table to be deleted

ClearRange bool

Clear the rage if set to true

GetEnumerator()

Gets the enumerator for the collection

public IEnumerator<ExcelTable> GetEnumerator()

Returns

IEnumerator<ExcelTable>

The enumerator

GetFromRange(ExcelRangeBase)

Get the table object from a range.

public ExcelTable GetFromRange(ExcelRangeBase Range)

Parameters

Range ExcelRangeBase

The range

Returns

ExcelTable

The table. Null if no range matches