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.
Namespace: ETLBox.Excel
Assembly: ETLBox.Excel.dll
Syntax
{{< /rawhtml >}}
```C#
[AttributeUsage(AttributeTargets.Property)]
public class ExcelColumn : Attribute
```
{{< rawhtml >}}
Examples
public class MyPoco
{
[ExcelColumn("HeaderName")]
public string ColumnByHeaderName { get; set; }
[ExcelColumn(2)]
public string ThirdColumnInExcel { get; set; }
}
Constructors
ExcelColumn()
Declaration
{{< /rawhtml >}}
```C#
public ExcelColumn()
```
{{< rawhtml >}}
ExcelColumn(int)
Declaration
{{< /rawhtml >}}
```C#
public ExcelColumn(int columnIndex)
```
{{< rawhtml >}}
Parameters
| Type |
Name |
Description |
| int |
columnIndex |
|
ExcelColumn(int, string)
Declaration
{{< /rawhtml >}}
```C#
public ExcelColumn(int columnIndex, string columnName)
```
{{< rawhtml >}}
Parameters
| Type |
Name |
Description |
| int |
columnIndex |
|
| string |
columnName |
|
ExcelColumn(string)
Declaration
{{< /rawhtml >}}
```C#
public ExcelColumn(string columnName)
```
{{< rawhtml >}}
Parameters
| Type |
Name |
Description |
| string |
columnName |
|
Properties
ColumnIndex
Declaration
{{< /rawhtml >}}
```C#
public int ColumnIndex { get; set; }
```
{{< rawhtml >}}
Property Value
ColumnName
Declaration
{{< /rawhtml >}}
```C#
public string ColumnName { get; set; }
```
{{< rawhtml >}}
Property Value
PropertyName
Declaration
{{< /rawhtml >}}
```C#
public string PropertyName { get; set; }
```
{{< rawhtml >}}
Property Value
{{< /rawhtml >}}