GrapeCity.Documents.Excel.IUniqueValues.ToJson

ToJson Method

ToJson()

Generates a JSON string from the conditional format.

Use this method to serialize the current unique-values or duplicate-values conditional formatting rule, including its settings and formatting, to a JSON string that can be reused with FromJson(string).

Declaration

string ToJson()

Function ToJson() As String

Returns

Type	Description
string	The conditional format JSON string.

Examples

worksheet.Range["A1:A5"].Value = new object[,] {
    {1}, {2}, {1}, {3}, {4}
};
IUniqueValues condition = worksheet.Range["A1:A5"].FormatConditions.AddUniqueValues();
condition.Interior.Color = Color.Yellow;
condition.DupeUnique = DupeUnique.Unique;
string json = condition.ToJson();