Class DataColumnMapping

Class used to map columns in the ToDataTable(ToDataTableOptions, DataTable) method

Inheritance

Object

DataColumnMapping

Inherited Members

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 DataColumnMapping

Properties

AllowNull

Indicates whether empty cell values should be allowed. Corresponds to System.Data.DataColumn.AllowDBNull

Declaration

public bool AllowNull { get; set; }

Property Value

Type	Description
Boolean

ColumnDataType

Type of the column, corresponds to System.Data.DataColumn.DataType

Declaration

public Type ColumnDataType { get; set; }

Property Value

Type	Description
Type

DataColumn

The System.Data.DataColumn used for the mapping

Declaration

public DataColumn DataColumn { get; }

Property Value

Type	Description
DataColumn

DataColumnName

Name of the data column, corresponds to System.Data.DataColumn.ColumnName

Declaration

public string DataColumnName { get; set; }

Property Value

Type	Description
String

TransformCellValue

A function which allows casting of an System.Object before it is written to the System.Data.DataTable

Declaration

public Func<object, object> TransformCellValue { get; set; }

Property Value

Type	Description
Func<Object, Object>

Examples

var options = ToDataTableOptions.Create(o =>
{
    // the last argument is a lambda function that will call the read value's ToString method
    // and this string will be written to the DataTable
    o.Mappings.Add(0, "Id", typeof(string), true, c => "Id: " + c.ToString());
});

ZeroBasedColumnIndexInRange

Zero based index of the mappings column in the range

Declaration

public int ZeroBasedColumnIndexInRange { get; set; }

Property Value

Type	Description
Int32