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.v20.2.Core.dll

NuGet Packages: DevExpress.Printing.Core, DevExpress.WindowsDesktop.Printing.Core

Declaration

C#

public struct XlVariantValue :
    IEquatable<XlVariantValue>

VB.NET

Public Structure XlVariantValue
    Implements IEquatable(Of XlVariantValue)

Related API Members

The following members return XlVariantValue objects:

• IXlCell.Value
• IXlCellError.Value
• XlCustomFilterCriteria.Value
• XlDynamicFilter.MaxValue
• XlDynamicFilter.Value
• XlVariantValue.FromObject(Object)
• XlVariantValue.ToText()
• XlVariantValue.ToText(CultureInfo)

Remarks

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.