Excel.ExcelWorksheetColumn Class
Namespace: Nucleus.Extensions.Excel
Assembly: Nucleus.Extensions.dll
Class representing a worksheet column in an Excel export.
Constructors
Nucleus.Extensions.Excel.ExcelWorksheetColumn Constructor
Nucleus.Extensions.Excel.ExcelWorksheetColumn (String name, String caption, Nullable<XLDataType> dataType)
Constructor used when you want to specify the name, caption and data type.
Nucleus.Extensions.Excel.ExcelWorksheetColumn Constructor
Nucleus.Extensions.Excel.ExcelWorksheetColumn (String name, String caption, Nullable<XLDataType> dataType, LambdaExpression expression)
Constructor used when you want to specify the name, caption and data type, and an expression to evaluate the data to output.
Parameters
| Name | Type |
|---|---|
| name | String |
| caption | String |
| dataType | System.Nullable<ClosedXML.Excel.XLDataType> |
| expression | System.Linq.Expressions.LambdaExpression |
Nucleus.Extensions.Excel.ExcelWorksheetColumn Constructor
Nucleus.Extensions.Excel.ExcelWorksheetColumn (PropertyInfo propertyInfo)
Constructed used to auto-detect column properties.
Parameters
| Name | Type |
|---|---|
| propertyInfo | System.Reflection.PropertyInfo |
Properties
PropertyInfo Property
PropertyInfo instance used when creating the column using reflection. This value is used during export to improve performance.
Expression Property
If set, specifies the expression to evaluate in order to derive a value.
Name Property
Column name. This is the unique identifier for the column.
Caption Property
Caption used in the heading row.
Index Property
Current cell index.
DataType Property
Excel data type for the column.