Class ExcelColumn

This attribute defines either which column index is mapped to the property or the header name that identifies the column By default, when reading from an excel file, a header column is expected in the first row. The name of the header is used to match with the property names of the object. With this attribute, you can define the column index of the excel column for the property or a different header name for a property. The index starts at 0.

Inheritance
object
System.Attribute
ExcelColumn
Inherited Members
System.Attribute.Equals(object)
System.Attribute.GetCustomAttribute(System.Reflection.Assembly, System.Type)
System.Attribute.GetCustomAttribute(System.Reflection.Assembly, System.Type, bool)
System.Attribute.GetCustomAttribute(System.Reflection.MemberInfo, System.Type)
System.Attribute.GetCustomAttribute(System.Reflection.MemberInfo, System.Type, bool)
System.Attribute.GetCustomAttribute(System.Reflection.Module, System.Type)
System.Attribute.GetCustomAttribute(System.Reflection.Module, System.Type, bool)
System.Attribute.GetCustomAttribute(System.Reflection.ParameterInfo, System.Type)
System.Attribute.GetCustomAttribute(System.Reflection.ParameterInfo, System.Type, bool)
System.Attribute.GetCustomAttributes(System.Reflection.Assembly)
System.Attribute.GetCustomAttributes(System.Reflection.Assembly, bool)
System.Attribute.GetCustomAttributes(System.Reflection.Assembly, System.Type)
System.Attribute.GetCustomAttributes(System.Reflection.Assembly, System.Type, bool)
System.Attribute.GetCustomAttributes(System.Reflection.MemberInfo)
System.Attribute.GetCustomAttributes(System.Reflection.MemberInfo, bool)
System.Attribute.GetCustomAttributes(System.Reflection.MemberInfo, System.Type)
System.Attribute.GetCustomAttributes(System.Reflection.MemberInfo, System.Type, bool)
System.Attribute.GetCustomAttributes(System.Reflection.Module)
System.Attribute.GetCustomAttributes(System.Reflection.Module, bool)
System.Attribute.GetCustomAttributes(System.Reflection.Module, System.Type)
System.Attribute.GetCustomAttributes(System.Reflection.Module, System.Type, bool)
System.Attribute.GetCustomAttributes(System.Reflection.ParameterInfo)
System.Attribute.GetCustomAttributes(System.Reflection.ParameterInfo, bool)
System.Attribute.GetCustomAttributes(System.Reflection.ParameterInfo, System.Type)
System.Attribute.GetCustomAttributes(System.Reflection.ParameterInfo, System.Type, bool)
System.Attribute.GetHashCode()
System.Attribute.IsDefaultAttribute()
System.Attribute.IsDefined(System.Reflection.Assembly, System.Type)
System.Attribute.IsDefined(System.Reflection.Assembly, System.Type, bool)
System.Attribute.IsDefined(System.Reflection.MemberInfo, System.Type)
System.Attribute.IsDefined(System.Reflection.MemberInfo, System.Type, bool)
System.Attribute.IsDefined(System.Reflection.Module, System.Type)
System.Attribute.IsDefined(System.Reflection.Module, System.Type, bool)
System.Attribute.IsDefined(System.Reflection.ParameterInfo, System.Type)
System.Attribute.IsDefined(System.Reflection.ParameterInfo, System.Type, bool)
System.Attribute.Match(object)
System.Attribute.TypeId
object.Equals(object, object)
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object, object)
object.ToString()
Namespace: ETLBox.DataFlow
Assembly: ETLBox.Excel.dll
Syntax
    [AttributeUsage(AttributeTargets.Property)]
public class ExcelColumn : Attribute
Examples

public class MyPoco { [ExcelColumn("HeaderName")] public string ColumnByHeaderName { get; set; } [ExcelColumn(2)] public string ThirdColumnInExcel { get; set; } }

Constructors

ExcelColumn()

Declaration
    public ExcelColumn()
Examples

public class MyPoco { [ExcelColumn("HeaderName")] public string ColumnByHeaderName { get; set; } [ExcelColumn(2)] public string ThirdColumnInExcel { get; set; } }

ExcelColumn(int, string)

Declaration
    public ExcelColumn(int columnIndex, string columnName)
Parameters
TypeNameDescription
intcolumnIndex
stringcolumnName
Examples

public class MyPoco { [ExcelColumn("HeaderName")] public string ColumnByHeaderName { get; set; } [ExcelColumn(2)] public string ThirdColumnInExcel { get; set; } }

ExcelColumn(int)

Declaration
    public ExcelColumn(int columnIndex)
Parameters
TypeNameDescription
intcolumnIndex
Examples

public class MyPoco { [ExcelColumn("HeaderName")] public string ColumnByHeaderName { get; set; } [ExcelColumn(2)] public string ThirdColumnInExcel { get; set; } }

ExcelColumn(string)

Declaration
    public ExcelColumn(string columnName)
Parameters
TypeNameDescription
stringcolumnName
Examples

public class MyPoco { [ExcelColumn("HeaderName")] public string ColumnByHeaderName { get; set; } [ExcelColumn(2)] public string ThirdColumnInExcel { get; set; } }

Properties

ColumnIndex

Declaration
    public int ColumnIndex { get; set; }
Property Value
TypeDescription
int
Examples

public class MyPoco { [ExcelColumn("HeaderName")] public string ColumnByHeaderName { get; set; } [ExcelColumn(2)] public string ThirdColumnInExcel { get; set; } }

ColumnName

Declaration
    public string ColumnName { get; set; }
Property Value
TypeDescription
string
Examples

public class MyPoco { [ExcelColumn("HeaderName")] public string ColumnByHeaderName { get; set; } [ExcelColumn(2)] public string ThirdColumnInExcel { get; set; } }

PropertyName

Declaration
    public string PropertyName { get; set; }
Property Value
TypeDescription
string
Examples

public class MyPoco { [ExcelColumn("HeaderName")] public string ColumnByHeaderName { get; set; } [ExcelColumn(2)] public string ThirdColumnInExcel { get; set; } }