ICellValueConverter Interface
A converter that converts custom objects to cell values and vice versa.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Related API Members
The following members return ICellValueConverter objects:
Example
To convert custom objects to cell values and vise versa, you can apply your own converters.
This example demonstrates how to convert a color object (Color) to a SpreadsheetControl-compatible cell value of the text type (CellValue) that corresponds to the color name. To do this, create a custom converter class that implements the ICellValueConverter interface, and call the CellValue.FromObject method with the color object and custom converter passed as parameters.
Worksheet worksheet = workbook.Worksheets[0];
Cell cell = worksheet.Cells["A1"];
cell.FillColor = Color.Orange;
cell.Value = CellValue.FromObject(cell.FillColor, new ColorToNameConverter());
// ...
class ColorToNameConverter : ICellValueConverter {
object ICellValueConverter.ConvertToObject(CellValue value) {
return null;
}
CellValue ICellValueConverter.TryConvertFromObject(object value) {
bool isColor = value.GetType() == typeof(Color);
if (!isColor)
return null;
return ((Color)value).Name;
}
}