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.v18.1.Core.dll

Declaration

C#

public struct XlVariantValue

VB.NET

Public Structure XlVariantValue

Related API Members

The following members accept/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.

Related GitHub Examples

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

Note

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.

C#

how-to-use-the-excel-export-api-to-generate-an-invoice-t252983/CS/XLExportExample/Form1.cs#L327

using (IXlCell cell = row.CreateCell()) {
    cell.Value = XlVariantValue.FromObject(value);
    cell.ApplyFormatting(rightPanelFormatting);

how-to-copy-cell-data-in-an-excel-format-biff8-to-the-clipboard-using-xl-export-library-t266171/CS/gridCopyToClipboardExample/CopyToClipboardHelper.cs#L66

// Set cell value
cell.Value = XlVariantValue.FromObject(this.view.GetRowCellValue(gridRowHandle, gridColumn));

excel-export-api-examples-t253492/CS/XLExportExamples/SpreadsheetActions/GeneralActions.cs#L277

using (IXlCell cell = row.CreateCell()) {
    cell.Value = XlVariantValue.ErrorName;
}

VB.NET

how-to-use-the-excel-export-api-to-generate-an-invoice-t252983/VB/XLExportExample/Form1.vb#L339

Using cell As IXlCell = row.CreateCell()
    cell.Value = XlVariantValue.FromObject(value)
    cell.ApplyFormatting(rightPanelFormatting)

how-to-copy-cell-data-in-an-excel-format-biff8-to-the-clipboard-using-xl-export-library-t266171/VB/gridCopyToClipboardExample/CopyToClipboardHelper.vb#L69

' Set cell value
cell.Value = XlVariantValue.FromObject(Me.view.GetRowCellValue(gridRowHandle, gridColumn))

excel-export-api-examples-t253492/VB/XLExportExamples/SpreadsheetActions/GeneralActions.vb#L271

Using cell As IXlCell = row.CreateCell()
    cell.Value = XlVariantValue.ErrorName
End Using