Class DataColumnMappingCollection

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

Inheritance

Object

List<DataColumnMapping>

DataColumnMappingCollection

Implements

IList<DataColumnMapping>

ICollection<DataColumnMapping>

IReadOnlyList<DataColumnMapping>

IReadOnlyCollection<DataColumnMapping>

IEnumerable<DataColumnMapping>

IList

ICollection

IEnumerable

Inherited Members

List<DataColumnMapping>.IList.get_Item(Int32)

List<DataColumnMapping>.IList.set_Item(Int32, Object)

List<DataColumnMapping>.Add(DataColumnMapping)

List<DataColumnMapping>.AddRange(IEnumerable<DataColumnMapping>)

List<DataColumnMapping>.AsReadOnly()

List<DataColumnMapping>.BinarySearch(Int32, Int32, DataColumnMapping, IComparer<DataColumnMapping>)

List<DataColumnMapping>.BinarySearch(DataColumnMapping)

List<DataColumnMapping>.BinarySearch(DataColumnMapping, IComparer<DataColumnMapping>)

List<DataColumnMapping>.Clear()

List<DataColumnMapping>.Contains(DataColumnMapping)

List<DataColumnMapping>.ConvertAll<TOutput>(Converter<DataColumnMapping, TOutput>)

List<DataColumnMapping>.CopyTo(Int32, DataColumnMapping[], Int32, Int32)

List<DataColumnMapping>.CopyTo(DataColumnMapping[])

List<DataColumnMapping>.CopyTo(DataColumnMapping[], Int32)

List<DataColumnMapping>.EnsureCapacity(Int32)

List<DataColumnMapping>.Exists(Predicate<DataColumnMapping>)

List<DataColumnMapping>.Find(Predicate<DataColumnMapping>)

List<DataColumnMapping>.FindAll(Predicate<DataColumnMapping>)

List<DataColumnMapping>.FindIndex(Int32, Int32, Predicate<DataColumnMapping>)

List<DataColumnMapping>.FindIndex(Int32, Predicate<DataColumnMapping>)

List<DataColumnMapping>.FindIndex(Predicate<DataColumnMapping>)

List<DataColumnMapping>.FindLast(Predicate<DataColumnMapping>)

List<DataColumnMapping>.FindLastIndex(Int32, Int32, Predicate<DataColumnMapping>)

List<DataColumnMapping>.FindLastIndex(Int32, Predicate<DataColumnMapping>)

List<DataColumnMapping>.FindLastIndex(Predicate<DataColumnMapping>)

List<DataColumnMapping>.ForEach(Action<DataColumnMapping>)

List<DataColumnMapping>.GetEnumerator()

List<DataColumnMapping>.GetRange(Int32, Int32)

List<DataColumnMapping>.IndexOf(DataColumnMapping)

List<DataColumnMapping>.IndexOf(DataColumnMapping, Int32)

List<DataColumnMapping>.IndexOf(DataColumnMapping, Int32, Int32)

List<DataColumnMapping>.Insert(Int32, DataColumnMapping)

List<DataColumnMapping>.InsertRange(Int32, IEnumerable<DataColumnMapping>)

List<DataColumnMapping>.LastIndexOf(DataColumnMapping)

List<DataColumnMapping>.LastIndexOf(DataColumnMapping, Int32)

List<DataColumnMapping>.LastIndexOf(DataColumnMapping, Int32, Int32)

List<DataColumnMapping>.Remove(DataColumnMapping)

List<DataColumnMapping>.RemoveAll(Predicate<DataColumnMapping>)

List<DataColumnMapping>.RemoveAt(Int32)

List<DataColumnMapping>.RemoveRange(Int32, Int32)

List<DataColumnMapping>.Reverse()

List<DataColumnMapping>.Reverse(Int32, Int32)

List<DataColumnMapping>.Slice(Int32, Int32)

List<DataColumnMapping>.Sort()

List<DataColumnMapping>.Sort(IComparer<DataColumnMapping>)

List<DataColumnMapping>.Sort(Comparison<DataColumnMapping>)

List<DataColumnMapping>.Sort(Int32, Int32, IComparer<DataColumnMapping>)

List<DataColumnMapping>.IEnumerable<DataColumnMapping>.GetEnumerator()

List<DataColumnMapping>.ICollection.CopyTo(Array, Int32)

List<DataColumnMapping>.IEnumerable.GetEnumerator()

List<DataColumnMapping>.IList.Add(Object)

List<DataColumnMapping>.IList.Contains(Object)

List<DataColumnMapping>.IList.IndexOf(Object)

List<DataColumnMapping>.IList.Insert(Int32, Object)

List<DataColumnMapping>.IList.Remove(Object)

List<DataColumnMapping>.ToArray()

List<DataColumnMapping>.TrimExcess()

List<DataColumnMapping>.TrueForAll(Predicate<DataColumnMapping>)

List<DataColumnMapping>.Capacity

List<DataColumnMapping>.Count

List<DataColumnMapping>.Item[Int32]

List<DataColumnMapping>.ICollection<DataColumnMapping>.IsReadOnly

List<DataColumnMapping>.ICollection.IsSynchronized

List<DataColumnMapping>.ICollection.SyncRoot

List<DataColumnMapping>.IList.IsFixedSize

List<DataColumnMapping>.IList.IsReadOnly

List<DataColumnMapping>.IList.Item[Int32]

Object.Equals(Object)

Object.Equals(Object, Object)

Object.GetHashCode()

Object.GetType()

Object.MemberwiseClone()

Object.ReferenceEquals(Object, Object)

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
Int32	zeroBasedIndexInRange	Zero based index of the column in the source range
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
Int32	zeroBasedIndexInRange	Zero based index of the column in the source range
DataColumn	dataColumn	The destination System.Data.DataColumn in the System.Data.DataTable
Func<Object, Object>	transformCellValueFunc	A function that casts/transforms the value before it is written to the System.Data.DataTable

Add(Int32, String)

Adds a DataColumnMapping

Declaration

public void Add(int zeroBasedIndexInRange, string columnName)

Parameters

Type	Name	Description
Int32	zeroBasedIndexInRange	Zero based index of the column in the source range
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
Int32	zeroBasedIndexInRange	Zero based index of the column in the source range
String	columnName	Name of the System.Data.DataColumn in the System.Data.DataTable
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
Int32	zeroBasedIndexInRange	Zero based index of the column in the source range
String	columnName	Name of the System.Data.DataColumn in the System.Data.DataTable
Func<Object, 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
Int32	zeroBasedIndexInRange	Zero based index of the column in the source range
String	columnName	Name of the System.Data.DataColumn in the System.Data.DataTable
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
Int32	zeroBasedIndexInRange	Zero based index of the column in the source range
String	columnName	Name of the System.Data.DataColumn in the System.Data.DataTable
Type	columnDataType	System.Type of the System.Data.DataColumn
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
Int32	zeroBasedIndexInRange	Zero based index of the column in the source range
String	columnName	Name of the System.Data.DataColumn in the System.Data.DataTable
Type	columnDataType	System.Type of the System.Data.DataColumn
Boolean	allowNull	Indicates if values read from the source range can be null
Func<Object, Object>	transformCellValueFunc	A function that casts/transforms the value before it is written to the System.Data.DataTable

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

Class DataColumnMappingCollection

Inheritance

Implements

Inherited Members

Namespace: OfficeOpenXml.Export.ToDataTable

Assembly: EPPlus.dll

Syntax

Methods

Add(Int32, DataColumn)

Declaration

Parameters

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

Declaration

Parameters

See Also

Add(Int32, String)

Declaration

Parameters

Add(Int32, String, Boolean)

Declaration

Parameters

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

Declaration

Parameters

Add(Int32, String, Type)

Declaration

Parameters

Add(Int32, String, Type, Boolean)

Declaration

Parameters

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

Declaration

Parameters

See Also

Implements