Class DataColumnMappingCollection

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

Inheritance
System.Object
System.Collections.Generic.List<DataColumnMapping>
DataColumnMappingCollection
Implements
System.Collections.Generic.IList<DataColumnMapping>
System.Collections.Generic.ICollection<DataColumnMapping>
System.Collections.Generic.IReadOnlyList<DataColumnMapping>
System.Collections.Generic.IReadOnlyCollection<DataColumnMapping>
System.Collections.Generic.IEnumerable<DataColumnMapping>
System.Collections.IList
System.Collections.ICollection
System.Collections.IEnumerable
Inherited Members
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.System.Collections.IList.get_Item(System.Int32)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.System.Collections.IList.set_Item(System.Int32, System.Object)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.Add(OfficeOpenXml.Export.ToDataTable.DataColumnMapping)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.AddRange(System.Collections.Generic.IEnumerable<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.AsReadOnly()
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.BinarySearch(System.Int32, System.Int32, OfficeOpenXml.Export.ToDataTable.DataColumnMapping, System.Collections.Generic.IComparer<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.BinarySearch(OfficeOpenXml.Export.ToDataTable.DataColumnMapping)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.BinarySearch(OfficeOpenXml.Export.ToDataTable.DataColumnMapping, System.Collections.Generic.IComparer<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.Clear()
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.Contains(OfficeOpenXml.Export.ToDataTable.DataColumnMapping)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.ConvertAll<TOutput>(System.Converter<OfficeOpenXml.Export.ToDataTable.DataColumnMapping, TOutput>)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.CopyTo(System.Int32, OfficeOpenXml.Export.ToDataTable.DataColumnMapping[], System.Int32, System.Int32)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.CopyTo(OfficeOpenXml.Export.ToDataTable.DataColumnMapping[])
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.CopyTo(OfficeOpenXml.Export.ToDataTable.DataColumnMapping[], System.Int32)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.Exists(System.Predicate<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.Find(System.Predicate<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.FindAll(System.Predicate<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.FindIndex(System.Int32, System.Int32, System.Predicate<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.FindIndex(System.Int32, System.Predicate<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.FindIndex(System.Predicate<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.FindLast(System.Predicate<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.FindLastIndex(System.Int32, System.Int32, System.Predicate<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.FindLastIndex(System.Int32, System.Predicate<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.FindLastIndex(System.Predicate<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.ForEach(System.Action<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.GetEnumerator()
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.GetRange(System.Int32, System.Int32)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.IndexOf(OfficeOpenXml.Export.ToDataTable.DataColumnMapping)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.IndexOf(OfficeOpenXml.Export.ToDataTable.DataColumnMapping, System.Int32)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.IndexOf(OfficeOpenXml.Export.ToDataTable.DataColumnMapping, System.Int32, System.Int32)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.Insert(System.Int32, OfficeOpenXml.Export.ToDataTable.DataColumnMapping)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.InsertRange(System.Int32, System.Collections.Generic.IEnumerable<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.LastIndexOf(OfficeOpenXml.Export.ToDataTable.DataColumnMapping)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.LastIndexOf(OfficeOpenXml.Export.ToDataTable.DataColumnMapping, System.Int32)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.LastIndexOf(OfficeOpenXml.Export.ToDataTable.DataColumnMapping, System.Int32, System.Int32)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.Remove(OfficeOpenXml.Export.ToDataTable.DataColumnMapping)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.RemoveAll(System.Predicate<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.RemoveAt(System.Int32)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.RemoveRange(System.Int32, System.Int32)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.Reverse()
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.Reverse(System.Int32, System.Int32)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.Sort()
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.Sort(System.Collections.Generic.IComparer<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.Sort(System.Comparison<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.Sort(System.Int32, System.Int32, System.Collections.Generic.IComparer<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.System.Collections.Generic.IEnumerable<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.GetEnumerator()
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.System.Collections.ICollection.CopyTo(System.Array, System.Int32)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.System.Collections.IEnumerable.GetEnumerator()
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.System.Collections.IList.Add(System.Object)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.System.Collections.IList.Contains(System.Object)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.System.Collections.IList.IndexOf(System.Object)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.System.Collections.IList.Insert(System.Int32, System.Object)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.System.Collections.IList.Remove(System.Object)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.ToArray()
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.TrimExcess()
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.TrueForAll(System.Predicate<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>)
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.Capacity
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.Count
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.Item[System.Int32]
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.System.Collections.Generic.ICollection<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.IsReadOnly
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.System.Collections.ICollection.IsSynchronized
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.System.Collections.ICollection.SyncRoot
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.System.Collections.IList.IsFixedSize
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.System.Collections.IList.IsReadOnly
System.Collections.Generic.List<OfficeOpenXml.Export.ToDataTable.DataColumnMapping>.System.Collections.IList.Item[System.Int32]
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: OfficeOpenXml.Export.ToDataTable
Assembly: EPPlus.dll
Syntax
public class DataColumnMappingCollection : List<DataColumnMapping>, IList<DataColumnMapping>, ICollection<DataColumnMapping>, IReadOnlyList<DataColumnMapping>, IReadOnlyCollection<DataColumnMapping>, IEnumerable<DataColumnMapping>, IList, ICollection, IEnumerable

Methods

Add(Int32, DataColumn)

Adds a DataColumnMapping

Declaration
public void Add(int zeroBasedIndexInRange, DataColumn dataColumn)
Parameters
Type Name Description
System.Int32 zeroBasedIndexInRange

Zero based index of the column in the source range
System.Data.DataColumn dataColumn

The destination System.Data.DataColumn in the System.Data.DataTable

Add(Int32, DataColumn, Func<Object, Object>)

Adds a DataColumnMapping

Declaration
public void Add(int zeroBasedIndexInRange, DataColumn dataColumn, Func<object, object> transformCellValueFunc)
Parameters
Type Name Description
System.Int32 zeroBasedIndexInRange

Zero based index of the column in the source range
System.Data.DataColumn dataColumn

The destination System.Data.DataColumn in the System.Data.DataTable
System.Func<System.Object, System.Object> transformCellValueFunc

A function that casts/transforms the value before it is written to the System.Data.DataTable
See Also

Add(Int32, String)

Adds a DataColumnMapping

Declaration
public void Add(int zeroBasedIndexInRange, string columnName)
Parameters
Type Name Description
System.Int32 zeroBasedIndexInRange

Zero based index of the column in the source range
System.String columnName

Name of the System.Data.DataColumn in the System.Data.DataTable

Add(Int32, String, Boolean)

Adds a DataColumnMapping

Declaration
public void Add(int zeroBasedIndexInRange, string columnName, bool allowNull)
Parameters
Type Name Description
System.Int32 zeroBasedIndexInRange

Zero based index of the column in the source range
System.String columnName

Name of the System.Data.DataColumn in the System.Data.DataTable
System.Boolean allowNull

Indicates if values read from the source range can be null

Add(Int32, String, Func<Object, Object>)

Adds a DataColumnMapping

Declaration
public void Add(int zeroBasedIndexInRange, string columnName, Func<object, object> transformCellValueFunc)
Parameters
Type Name Description
System.Int32 zeroBasedIndexInRange

Zero based index of the column in the source range
System.String columnName

Name of the System.Data.DataColumn in the System.Data.DataTable
System.Func<System.Object, System.Object> transformCellValueFunc

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

Add(Int32, String, Type)

Adds a DataColumnMapping

Declaration
public void Add(int zeroBasedIndexInRange, string columnName, Type columnDataType)
Parameters
Type Name Description
System.Int32 zeroBasedIndexInRange

Zero based index of the column in the source range
System.String columnName

Name of the System.Data.DataColumn in the System.Data.DataTable
System.Type columnDataType

System.Type of the System.Data.DataColumn

Add(Int32, String, Type, Boolean)

Adds a DataColumnMapping

Declaration
public void Add(int zeroBasedIndexInRange, string columnName, Type columnDataType, bool allowNull)
Parameters
Type Name Description
System.Int32 zeroBasedIndexInRange

Zero based index of the column in the source range
System.String columnName

Name of the System.Data.DataColumn in the System.Data.DataTable
System.Type columnDataType

System.Type of the System.Data.DataColumn
System.Boolean allowNull

Indicates if values read from the source range can be null

Add(Int32, String, Type, Boolean, Func<Object, Object>)

Adds a DataColumnMapping

Declaration
public void Add(int zeroBasedIndexInRange, string columnName, Type columnDataType, bool allowNull, Func<object, object> transformCellValueFunc)
Parameters
Type Name Description
System.Int32 zeroBasedIndexInRange

Zero based index of the column in the source range
System.String columnName

Name of the System.Data.DataColumn in the System.Data.DataTable
System.Type columnDataType

System.Type of the System.Data.DataColumn
System.Boolean allowNull

Indicates if values read from the source range can be null
System.Func<System.Object, System.Object> transformCellValueFunc

A function that casts/transforms the value before it is written to the System.Data.DataTable
See Also

Implements

System.Collections.Generic.IList<T>
System.Collections.Generic.ICollection<T>
System.Collections.Generic.IReadOnlyList<T>
System.Collections.Generic.IReadOnlyCollection<T>
System.Collections.Generic.IEnumerable<T>
System.Collections.IList
System.Collections.ICollection
System.Collections.IEnumerable