IXlTable.DataFormatting Property
Gets or sets format characteristics for the data area of the table.
Namespace: DevExpress.Export.Xl
Assembly: DevExpress.Printing.v23.2.Core.dll
NuGet Package: DevExpress.Printing.Core
Declaration
Property Value
| Type | Description |
|---|---|
| DevExpress.Export.Xl.XlDifferentialFormatting | An XlDifferentialFormatting instance that specifies format characteristics applied to the table’s data area. |
Remarks
Use the DataFormatting property to apply custom formatting to the cell range that contains table data. In particular, you can color the cell background, adjust font settings, align the cell content, add borders and specify number format options. To do this, use properties of the XlDifferentialFormatting object inherited from the XlFormatting class: XlFormatting.Fill, XlFormatting.Font, XlFormatting.Alignment, XlFormatting.Border and XlFormatting.NumberFormat. Moreover, the XlDifferentialFormatting object implements implicit conversion from the XlFill, XlFont, XlCellAlignment, XlBorder and XlNumberFormat objects, so that you can directly assign an object containing the required format settings to the DataFormatting property without using unnecessary cast operators.
To apply special formatting to the data area of a particular table column, use the IXlTableColumn.DataFormatting property.
For more information on how to set custom formatting for different table regions and individual table columns, refer to the How to: Apply Custom Formatting to a Table example.