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

NuGet Package : DevExpress.Printing.Core

Declaration

• C#
• VB.NET

public struct XlVariantValue :
    IEquatable<XlVariantValue>

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), string (Char, String), and image (Byte[]) 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, XlVariantValue.ErrorValue, or XlVariantValue.ImageValue property.

See Also

XlVariantValue Members

Use the Excel Export API to Create a Worksheet Cell and Set Its Value

Use the Excel Export API to Create a Cell Formula

Data Filtering in the Excel Export Library

DevExpress.Export.Xl Namespace