XlVariantValue Struct

A variant value that can be used as a cell value, filter value or function argument.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v21.2.Core.dll


public struct XlVariantValue :


The XlVariantValue object supports implicit conversion from the numeric (Int32, Int64, Double, and Single), date and time (DateTime, TimeSpan), boolean (Boolean) and string (Char, String) types to eliminate unnecessary casts. You can also use the XlVariantValue.FromObject method to convert a specific object to XlVariantValue.

To obtain the XlVariantValue object’s type, use the XlVariantValue.Type property. To get an object of the corresponding type from the XlVariantValue object, use the XlVariantValue.TextValue, XlVariantValue.NumericValue, XlVariantValue.DateTimeValue, XlVariantValue.BooleanValue or XlVariantValue.ErrorValue property.

The following code snippets (auto-collected from DevExpress Examples) contain references to the XlVariantValue struct.


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.

See Also