Class ExcelTableCollection
A collection of table objects
Inheritance
System.Object
ExcelTableCollection
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Experior.Core.Data.OfficeOpenXml.Table
Assembly: Experior.Core.dll
Syntax
public class ExcelTableCollection : IEnumerable<ExcelTable>, IEnumerableProperties
Count
Number of items in the collection
Declaration
public int Count { get; }Property Value
| Type | Description |
|---|---|
| System.Int32 |
Item[Int32]
The table Index. Base 0.
Declaration
public ExcelTable this[int Index] { get; }Parameters
| Type | Name | Description |
|---|---|---|
| System.Int32 | Index |
Property Value
| Type | Description |
|---|---|
| ExcelTable |
Item[String]
Indexer
Declaration
public ExcelTable this[string Name] { get; }Parameters
| Type | Name | Description |
|---|---|---|
| System.String | Name | The name of the table |
Property Value
| Type | Description |
|---|---|
| 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
Declaration
public ExcelTable Add(ExcelAddressBase Range, string Name)Parameters
| Type | Name | Description |
|---|---|---|
| ExcelAddressBase | Range | The range address including header and total row |
| System.String | Name | The name of the table. Must be unique |
Returns
| Type | Description |
|---|---|
| ExcelTable | The table object |
GetEnumerator()
Declaration
public IEnumerator<ExcelTable> GetEnumerator()Returns
| Type | Description |
|---|---|
| System.Collections.Generic.IEnumerator<ExcelTable> |
GetFromRange(ExcelRangeBase)
Get the table object from a range.
Declaration
public ExcelTable GetFromRange(ExcelRangeBase Range)Parameters
| Type | Name | Description |
|---|---|---|
| ExcelRangeBase | Range | The range |
Returns
| Type | Description |
|---|---|
| ExcelTable | The table. Null if no range matches |
Explicit Interface Implementations
IEnumerable.GetEnumerator()
Declaration
IEnumerator IEnumerable.GetEnumerator()Returns
| Type | Description |
|---|---|
| System.Collections.IEnumerator |
Implements
System.Collections.Generic.IEnumerable<T>
System.Collections.IEnumerable