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