IXlRow.ApplyFormatting(XlCellFormatting) Method

Applies the specified formatting settings to the entire row.

Namespace: DevExpress.Export.Xl

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

Declaration

C#

void ApplyFormatting(
    XlCellFormatting formatting
)

VB.NET

Sub ApplyFormatting(
    formatting As XlCellFormatting
)

Parameters

Name	Type	Description
formatting	XlCellFormatting	An XlCellFormatting object that specifies format characteristics to be applied to row 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 row 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 pass an object specifying the required format characteristics to the ApplyFormatting method 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.