Nucleus .Net Core CMS

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.
Parameters
Name Type
name String
caption String
dataType System.Nullable<ClosedXML.Excel.XLDataType>

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.