GetSparkline Method (Worksheet)

Visual Basic
C#

'Declaration
 
Public Function GetSparkline( _
   ByVal row As Integer, _
   ByVal column As Integer _
) As Sparkline

'Usage
 
Dim instance As Worksheet
Dim row As Integer
Dim column As Integer
Dim value As Sparkline
 
value = instance.GetSparkline(row, column)

public Sparkline GetSparkline( 
   int row,
   int column
)

Parameters

row: The row.
column: The column.

Return Value

The sparkline of the cell.

This example uses the GetSparkline method.

C#
VB.NET

GrapeCity.Xaml.SpreadSheet.Data.CellRange cellr = new GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 1, 5);
GrapeCity.Xaml.SpreadSheet.Data.SparklineSetting ex = new GrapeCity.Xaml.SpreadSheet.Data.SparklineSetting();
ex.SeriesColor  = Windows.UI.Colors.Aquamarine; 
gcSpreadSheet1.Sheets[0].Cells[0, 0].Value = 2;
gcSpreadSheet1.Sheets[0].Cells[0, 1].Value = 5;
gcSpreadSheet1.Sheets[0].Cells[0, 2].Value = 4;
gcSpreadSheet1.Sheets[0].Cells[0, 3].Value = -1;
gcSpreadSheet1.Sheets[0].Cells[0, 4].Value = 3;
gcSpreadSheet1.Sheets[0].SetSparkline(0, 5, cellr, GrapeCity.Xaml.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Xaml.SpreadSheet.Data.SparklineType.Column, ex);         

        private void button1_Click(object sender, RoutedEventArgs e)
        {
            listBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetSparkline(0, 5).ToString());
            gcSpreadSheet1.Sheets[0].RemoveSparkline(0, 5);            
        }

Dim cellr As New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 1, 5)
Dim ex As New GrapeCity.Xaml.SpreadSheet.Data.SparklineSetting()
ex.SeriesColor = Windows.UI.Colors.Aquamarine
GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = 2
GcSpreadSheet1.Sheets(0).Cells(0, 1).Value = 5
GcSpreadSheet1.Sheets(0).Cells(0, 2).Value = 4
GcSpreadSheet1.Sheets(0).Cells(0, 3).Value = -1
GcSpreadSheet1.Sheets(0).Cells(0, 4).Value = 3
GcSpreadSheet1.Sheets(0).SetSparkline(0, 5, cellr, GrapeCity.Xaml.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Xaml.SpreadSheet.Data.SparklineType.Column, ex)

Private Sub Button_Click_1(sender As Object, e As RoutedEventArgs)
        ListBox1.Items.Add(gcSpreadSheet1.Sheets(0).GetSparkline(0, 5).ToString())
        gcSpreadSheet1.Sheets(0).RemoveSparkline(0, 5)
    End Sub

Target Platforms: Windows Server 2012, Windows RT

Reference

Worksheet Class
Worksheet Members