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 AllowDBNull

Declaration

public bool AllowNull { get; set; }

Property Value

Type	Description
bool

ColumnDataType

Type of the column, corresponds to DataType

Declaration

public Type ColumnDataType { get; set; }

Property Value

Type	Description
Type

DataColumn

The DataColumn used for the mapping

Declaration

public DataColumn DataColumn { get; }

Property Value

Type	Description
DataColumn

DataColumnName

Name of the data column, corresponds to ColumnName

Declaration

public string DataColumnName { get; set; }

Property Value

Type	Description
string

TransformCellValue

A function which allows casting of an object before it is written to the 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
int