ExcelWriter.WorksheetColumn Class
Namespace: Nucleus.Extensions.ExcelWriter
Assembly: Nucleus.Extensions.dll
Class representing a worksheet column in an Excel export.
Constructors
Nucleus.Extensions.ExcelWriter.WorksheetColumn Constructor
Nucleus.Extensions.ExcelWriter.WorksheetColumn (String name, String caption, Nullable<XLDataType> dataType)
Constructor used when you want to specify the name, caption and data type.
Nucleus.Extensions.ExcelWriter.WorksheetColumn Constructor
Nucleus.Extensions.ExcelWriter.WorksheetColumn (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.ExcelWriter.WorksheetColumn Constructor
Nucleus.Extensions.ExcelWriter.WorksheetColumn (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.
DataType Property
Excel data type for the column.