GrapeCity.Documents.Excel.IIconSetCondition.ToJson

ToJson Method

ToJson()

Generates a JSON string from the conditional format.

The returned string contains the serialized definition of this icon set conditional formatting rule.

Declaration

string ToJson()

Function ToJson() As String

Returns

Type	Description
string	The conditional format JSON string.

Examples

worksheet.Range["A1:A5"].Value = new object[,] {{10}, {30}, {50}, {70}, {90}};
IIconSetCondition condition = worksheet.Range["A1:A5"].FormatConditions.AddIconSetCondition();
condition.IconSet = workbook.IconSets[IconSetType.Icon3TrafficLights1];
string json = condition.ToJson();