GrapeCity.Documents.Excel.ISparkline

ISparkline Interface

Represents a single sparkline.

An ISparkline defines one sparkline item in a worksheet, including the cell that displays the sparkline and the source range used to generate it. Individual sparklines are typically obtained from an ISparklineGroup.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface ISparkline

Public Interface ISparkline

Examples

worksheet.Range["A1:C1"].Value = new object[] {10, 20, 15};
ISparklineGroup group = worksheet.Range["D1"].SparklineGroups.Add(SparkType.Line, "A1:C1");
ISparkline sparkline = group[0];
IRange location = sparkline.Location;
string sourceData = sparkline.SourceData;

Properties

Name	Description
Location	Gets or sets the location of a single sparkline. Returns the IRange object that represents the cell where the sparkline is displayed.
SourceData	Gets or sets the range that contains the source data for a single sparkline.

Name

Description

Location

Gets or sets the location of a single sparkline.

Returns the IRange object that represents the cell where the sparkline is displayed.

SourceData

Gets or sets the range that contains the source data for a single sparkline.

Methods

Name	Description
FromJson(string)	Generates the sparkline from the JSON string. Use this method to restore a sparkline from a JSON string created by ToJson().
ToJson()	Generates a JSON string from the sparkline. Use this method to serialize the current sparkline so it can be passed to FromJson(string) to restore the sparkline configuration.

Name

Description

FromJson(string)

Generates the sparkline from the JSON string.

Use this method to restore a sparkline from a JSON string created by ToJson().

ToJson()

Generates a JSON string from the sparkline.

Use this method to serialize the current sparkline so it can be passed to FromJson(string) to restore the sparkline configuration.