Skip to main content

IXlTable.DataFormatting Property

Gets or sets format characteristics for the data area of the table.

Namespace: DevExpress.Export.Xl

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

NuGet Package: DevExpress.Printing.Core

Declaration

XlDifferentialFormatting DataFormatting { get; set; }

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.

See Also