GrapeCity.Windows.SpreadSheet.Data Namespace > Worksheet Class : GetSparkline Method |
'Declaration Public Function GetSparkline( _ ByVal row As System.Integer, _ ByVal column As System.Integer _ ) As Sparkline
GrapeCity.Windows.SpreadSheet.Data.CellRange cellr = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 1, 5); GrapeCity.Windows.SpreadSheet.Data.SparklineSetting ex = new GrapeCity.Windows.SpreadSheet.Data.SparklineSetting(); ex.SeriesColor = System.Windows.Media.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.Windows.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Windows.SpreadSheet.Data.SparklineType.Column, ex); gcSpreadSheet1.Invalidate(); private void button1_Click(object sender, RoutedEventArgs e) { listBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetSparkline(0, 5).ToString()); gcSpreadSheet1.Sheets[0].RemoveSparkline(0, 5); gcSpreadSheet1.Invalidate(); }
Dim cellr As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 1, 5) Dim ex As New GrapeCity.Windows.SpreadSheet.Data.SparklineSetting() ex.SeriesColor = System.Windows.Media.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.Windows.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Windows.SpreadSheet.Data.SparklineType.Column, ex) GcSpreadSheet1.Invalidate() Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).GetSparkline(0, 5).ToString()) GcSpreadSheet1.Sheets(0).RemoveSparkline(0, 5) GcSpreadSheet1.Invalidate() End Sub
Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6