GrapeCity.Documents.Excel.ISparklineGroups.Clear

Clear Method

Clear()

Clears the selected sparklines.

Removes the sparkline objects from the cells in the associated range without clearing the underlying worksheet data. To remove entire sparkline groups, use ClearGroups() instead.

Declaration

void Clear()

Sub Clear()

Examples

object[,] data = new object[,] {
    {1, 2, 3},
    {4, 5, 6}
};
worksheet.Range["A1:C2"].Value = data;
worksheet.Range["D1:D2"].SparklineGroups.Add(SparkType.Line, "A1:C2");
worksheet.Range["D1"].SparklineGroups.Clear();