Class DataColumnMappingCollection¶

Namespace: OfficeOpenXml.Export.ToDataTable
Assembly: EPPlus.dll

A collection of DataColumnMappings that will be used when reading data from the source range.

public class DataColumnMappingCollection : List<DataColumnMapping>, IList<DataColumnMapping>, ICollection<DataColumnMapping>, IList, ICollection, IReadOnlyList<DataColumnMapping>, IReadOnlyCollection<DataColumnMapping>, IEnumerable<DataColumnMapping>, IEnumerable

Inheritance¶

object ← List<DataColumnMapping> ← DataColumnMappingCollection

Implements¶

ICollection
ICollection<DataColumnMapping>
IEnumerable
IEnumerable<DataColumnMapping>
IList
IList<DataColumnMapping>
IReadOnlyCollection<DataColumnMapping>
IReadOnlyList<DataColumnMapping>

Inherited Members¶

List<DataColumnMapping>.Add(DataColumnMapping)
List<DataColumnMapping>.AddRange(IEnumerable<DataColumnMapping>)
List<DataColumnMapping>.AsReadOnly()
List<DataColumnMapping>.BinarySearch(DataColumnMapping, IComparer<DataColumnMapping>?)
List<DataColumnMapping>.BinarySearch(DataColumnMapping)
List<DataColumnMapping>.BinarySearch(int, int, DataColumnMapping, IComparer<DataColumnMapping>?)
List<DataColumnMapping>.Capacity
List<DataColumnMapping>.Clear()
List<DataColumnMapping>.Contains(DataColumnMapping)
List<DataColumnMapping>.ConvertAll<TOutput>(Converter<DataColumnMapping, TOutput>)
List<DataColumnMapping>.CopyTo(DataColumnMapping[], int)
List<DataColumnMapping>.CopyTo(DataColumnMapping[])
List<DataColumnMapping>.CopyTo(int, DataColumnMapping[], int, int)
List<DataColumnMapping>.Count
List<DataColumnMapping>.EnsureCapacity(int)
List<DataColumnMapping>.Exists(Predicate<DataColumnMapping>)
List<DataColumnMapping>.Find(Predicate<DataColumnMapping>)
List<DataColumnMapping>.FindAll(Predicate<DataColumnMapping>)
List<DataColumnMapping>.FindIndex(int, int, Predicate<DataColumnMapping>)
List<DataColumnMapping>.FindIndex(int, Predicate<DataColumnMapping>)
List<DataColumnMapping>.FindIndex(Predicate<DataColumnMapping>)
List<DataColumnMapping>.FindLast(Predicate<DataColumnMapping>)
List<DataColumnMapping>.FindLastIndex(int, int, Predicate<DataColumnMapping>)
List<DataColumnMapping>.FindLastIndex(int, Predicate<DataColumnMapping>)
List<DataColumnMapping>.FindLastIndex(Predicate<DataColumnMapping>)
List<DataColumnMapping>.ForEach(Action<DataColumnMapping>)
List<DataColumnMapping>.GetEnumerator()
List<DataColumnMapping>.GetRange(int, int)
List<DataColumnMapping>.IndexOf(DataColumnMapping, int, int)
List<DataColumnMapping>.IndexOf(DataColumnMapping, int)
List<DataColumnMapping>.IndexOf(DataColumnMapping)
List<DataColumnMapping>.Insert(int, DataColumnMapping)
List<DataColumnMapping>.InsertRange(int, IEnumerable<DataColumnMapping>)
List<DataColumnMapping>.LastIndexOf(DataColumnMapping, int, int)
List<DataColumnMapping>.LastIndexOf(DataColumnMapping, int)
List<DataColumnMapping>.LastIndexOf(DataColumnMapping)
List<DataColumnMapping>.Remove(DataColumnMapping)
List<DataColumnMapping>.RemoveAll(Predicate<DataColumnMapping>)
List<DataColumnMapping>.RemoveAt(int)
List<DataColumnMapping>.RemoveRange(int, int)
List<DataColumnMapping>.Reverse()
List<DataColumnMapping>.Reverse(int, int)
List<DataColumnMapping>.Slice(int, int)
List<DataColumnMapping>.Sort()
List<DataColumnMapping>.Sort(Comparison<DataColumnMapping>)
List<DataColumnMapping>.Sort(IComparer<DataColumnMapping>?)
List<DataColumnMapping>.Sort(int, int, IComparer<DataColumnMapping>?)
List<DataColumnMapping>.this[int]
List<DataColumnMapping>.ToArray()
List<DataColumnMapping>.TrimExcess()
List<DataColumnMapping>.TrueForAll(Predicate<DataColumnMapping>)
object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Constructors¶

DataColumnMappingCollection()¶

public DataColumnMappingCollection()

Methods¶

Add(int, DataColumn)¶

Adds a DataColumnMapping

public void Add(int zeroBasedIndexInRange, DataColumn dataColumn)

Parameters¶

zeroBasedIndexInRange int

Zero based index of the column in the source range

dataColumn DataColumn

The destination DataColumn in the DataTable

Add(int, DataColumn, Func<object, object>)¶

Adds a DataColumnMapping

public void Add(int zeroBasedIndexInRange, DataColumn dataColumn, Func<object, object> transformCellValueFunc)

Parameters¶

zeroBasedIndexInRange int

Zero based index of the column in the source range

dataColumn DataColumn

The destination DataColumn in the DataTable

transformCellValueFunc Func<object, object>

A function that casts/transforms the value before it is written to the DataTable

See Also¶

DataColumnMapping.TransformCellValue

Add(int, string)¶

Adds a DataColumnMapping

public void Add(int zeroBasedIndexInRange, string columnName)

Parameters¶

zeroBasedIndexInRange int

Zero based index of the column in the source range

columnName string

Name of the DataColumn in the DataTable

Add(int, string, bool)¶

Adds a DataColumnMapping

public void Add(int zeroBasedIndexInRange, string columnName, bool allowNull)

Parameters¶

zeroBasedIndexInRange int

Zero based index of the column in the source range

columnName string

Name of the DataColumn in the DataTable

allowNull bool

Indicates if values read from the source range can be null

Add(int, string, Func<object, object>)¶

Adds a DataColumnMapping

public void Add(int zeroBasedIndexInRange, string columnName, Func<object, object> transformCellValueFunc)

Parameters¶

zeroBasedIndexInRange int

Zero based index of the column in the source range

columnName string

Name of the DataColumn in the DataTable

transformCellValueFunc Func<object, object>

A function that casts/transforms the value before it is written to the DataTable

Add(int, string, Type)¶

Adds a DataColumnMapping

public void Add(int zeroBasedIndexInRange, string columnName, Type columnDataType)

Parameters¶

zeroBasedIndexInRange int

Zero based index of the column in the source range

columnName string

Name of the DataColumn in the DataTable

columnDataType Type

Type of the DataColumn

Add(int, string, Type, bool)¶

Adds a DataColumnMapping

public void Add(int zeroBasedIndexInRange, string columnName, Type columnDataType, bool allowNull)

Parameters¶

zeroBasedIndexInRange int

Zero based index of the column in the source range

columnName string

Name of the DataColumn in the DataTable

columnDataType Type

Type of the DataColumn

allowNull bool

Indicates if values read from the source range can be null

Add(int, string, Type, bool, Func<object, object>)¶

Adds a DataColumnMapping

public void Add(int zeroBasedIndexInRange, string columnName, Type columnDataType, bool allowNull, Func<object, object> transformCellValueFunc)

Parameters¶

zeroBasedIndexInRange int

Zero based index of the column in the source range

columnName string

Name of the DataColumn in the DataTable

columnDataType Type

Type of the DataColumn

allowNull bool

Indicates if values read from the source range can be null

transformCellValueFunc Func<object, object>

A function that casts/transforms the value before it is written to the DataTable

See Also¶

DataColumnMapping.TransformCellValue