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

IList<DataColumnMapping>

ICollection<DataColumnMapping>

IList

ICollection

IReadOnlyList<DataColumnMapping>

IReadOnlyCollection<DataColumnMapping>

IEnumerable<DataColumnMapping>

IEnumerable

Inherited Members

List<DataColumnMapping>.Add(DataColumnMapping)

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

List<DataColumnMapping>.AsReadOnly()

List<DataColumnMapping>.BinarySearch(int, int, 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(DataColumnMapping[])

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

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

List<DataColumnMapping>.EnsureCapacity(int)

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

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

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

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

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

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

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

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

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

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

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

List<DataColumnMapping>.GetEnumerator()

List<DataColumnMapping>.GetRange(int, int)

List<DataColumnMapping>.Slice(int, int)

List<DataColumnMapping>.IndexOf(DataColumnMapping)

List<DataColumnMapping>.IndexOf(DataColumnMapping, int)

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

List<DataColumnMapping>.Insert(int, DataColumnMapping)

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

List<DataColumnMapping>.LastIndexOf(DataColumnMapping)

List<DataColumnMapping>.LastIndexOf(DataColumnMapping, int)

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

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>.Sort()

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

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

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

List<DataColumnMapping>.ToArray()

List<DataColumnMapping>.TrimExcess()

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

List<DataColumnMapping>.Capacity

List<DataColumnMapping>.Count

List<DataColumnMapping>.this[int]

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

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

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

TransformCellValue