IXlRow.ApplyFormatting(XlCellFormatting) Method
Applies the specified formatting settings to the entire row.
Namespace: DevExpress.Export.Xl
Assembly: DevExpress.Printing.v24.1.Core.dll
NuGet Package: DevExpress.Printing.Core
Declaration
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.
Related GitHub Examples
The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ApplyFormatting(XlCellFormatting) method.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.