IXlColumn.Formatting Property

Gets or sets format characteristics of the column.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

XlCellFormatting Formatting { get; set; }

VB.NET

Property Formatting As XlCellFormatting

Property Value

Type	Description
XlCellFormatting	An XlCellFormatting object that specifies format characteristics applied to column cells.

Remarks

The XlCellFormatting object provides a set of properties and methods to change cell format settings.

• To format cells using the predefined format settings corresponding to one of the Microsoft® Excel® styles, use static properties of the XlCellFormatting class (XlCellFormatting.Bad, XlCellFormatting.Good, XlCellFormatting.Neutral, etc.).
• To apply a predefined formatting that is based on the current document theme, use the XlCellFormatting.Themed method.
• To specify the custom formatting options for column cells, use properties inherited from the XlFormatting class: XlFormatting.Fill, XlFormatting.Font, XlFormatting.Alignment, XlFormatting.Border and XlFormatting.NumberFormat. Moreover, the XlCellFormatting object implements implicit conversion from the XlFill, XlFont, XlCellAlignment, XlBorder and XlNumberFormat objects, so that you can directly assign an object specifying the required format characteristics to the Formatting property without using unnecessary cast operators.

For more information on how to format cells in a worksheet, see the How to: Format a Cell document and the Formatting section of examples.