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>.EnsureCapacity(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>.Slice(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

TransformCellValue

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

TransformCellValue

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