GrapeCity.Documents.Excel.ISlicer.FromJson

FromJson Method

FromJson(string)

Updates the slicer settings from the specified JSON string.

Use this method to apply slicer settings that were generated by ToJson() to an existing slicer.

Declaration

void FromJson(string json)

Sub FromJson(json As String)

Parameters

Type	Name	Description
string	json	The JSON string that contains slicer settings.

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Name", "Value"},
    {"A", 100},
    {"B", 200},
    {"C", 300}
};
ITable table = worksheet.Tables.Add(worksheet.Range["A1:B4"], true);
ISlicerCache cache = workbook.SlicerCaches.Add(table, "Name");
ISlicer slicer = cache.Slicers.Add(worksheet, "Slicer", "Name Copy", 160, 20, 120, 180);
string json = "{\"name\":\"Slicer1\",\"x\":26.666666666666668,\"y\":26.666666666666668,\"width\":160,\"height\":240.00000000000003,\"startRow\":1,\"startColumn\":0,\"endRow\":13,\"endColumn\":2,\"startRowOffset\":6.666666666666667,\"startColumnOffset\":26.666666666666668,\"endRowOffset\":6.666666666666667,\"endColumnOffset\":58.666666666666664,\"dynamicMove\":false,\"dynamicSize\":false,\"nameInFormula\":\"Slicer_Name\",\"slicerCacheName\":\"Slicer_Name\",\"allowResize\":true,\"allowMove\":true,\"isVisible\":true,\"isSelected\":false,\"multiSelect\":false,\"isLocked\":true,\"disableResizingAndMoving\":false,\"type\":\"table\",\"captionName\":\"Name\",\"columnCount\":1,\"itemHeight\":19.666666666666668,\"showHeader\":true,\"style\":\"SlicerStyleLight1\"}";
slicer.FromJson(json);