menu

Xamarin.Forms

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Interface ISparklines - Xamarin.Forms API Reference | Syncfusion

    Show / Hide Table of Contents

    Interface ISparklines

    Represents the Spraklines in Sprakline chart

    Namespace: Syncfusion.XlsIO
    Assembly: Syncfusion.XlsIO.Portable.dll
    Syntax
    public interface ISparklines : IList<ISparkline>, ICollection<ISparkline>, IEnumerable<ISparkline>, IEnumerable

    Methods

    Add()

    Adds Sparkline instance.

    Declaration
    Sparkline Add()
    Returns
    Type Description
    Sparkline

    the Sprakline object

    Examples

    The following example demonstrates the Add method.

    ExcelEngine engine=new ExcelEngine();
    
    IApplication app= engine.Excel;
    
    app.DefaultVersion= ExcelVersion.Excel2010;
    
    IWorkbook wkBook= app.Workbooks.Create(2); 
    IWorksheet sheet= wkBook.Worksheets[0];
    
    ISparklineGroup spGroup= sheet.SparklineGroups.Add();
    
    //Initialize the Saprklines
    ISparklines sparklines=spGroup.Add(); 
    
    //returns the sparkline object.
    ISparkline sparkline=sparklines.Add();
    
    wkBook.SaveAs("Sample.xlsx");
    wkBook.Close();

    Add(IRange, IRange)

    Adds the sparkline.

    Declaration
    void Add(IRange dataRange, IRange referenceRange)
    Parameters
    Type Name Description
    IRange dataRange

    The data range.IRange

    IRange referenceRange

    The reference range.IRange

    Examples

    The following example demonstrates the Add method.

    ExcelEngine engine=new ExcelEngine();
    
    IApplication app= engine.Excel;
    
    app.DefaultVersion= ExcelVersion.Excel2010;
    
    IWorkbook wkBook= app.Workbooks.Create(2); 
    IWorksheet sheet= wkBook.Worksheets[0];
    
    ISparklineGroup spGroup= sheet.SparklineGroups.Add();
    
    //Initialize the Sparklines
    ISparklines sparklines=spGroup.Add(); 
    
    //Add the Sparklines data range and reference range.
    sparklines.Add(sheet.Range["A1:B2"],sheet.Range["C1"]);
    
    wkBook.SaveAs("Sample.xlsx");
    wkBook.Close();

    Add(IRange, IRange, Boolean)

    Adds the sparkline.

    Declaration
    void Add(IRange dataRange, IRange referenceRange, bool isVertical)
    Parameters
    Type Name Description
    IRange dataRange

    The data range.IRange

    IRange referenceRange

    The reference range.IRange

    System.Boolean isVertical

    Specifies whether to plot the sparklines from the new data range by row or by column.

    Examples

    The following example demonstrates the Add method.

    ExcelEngine engine=new ExcelEngine();
    
    IApplication app= engine.Excel;
    
    app.DefaultVersion= ExcelVersion.Excel2010;
    
    IWorkbook wkBook= app.Workbooks.Create(2); 
    IWorksheet sheet= wkBook.Worksheets[0];
    
    ISparklineGroup spGroup= sheet.SparklineGroups.Add();
    
    //Initialize the Sparklines
    ISparklines sparklines=spGroup.Add(); 
    
    //Add the Sparklines data range and reference range.
    sparklines.Add(sheet.Range["A1:B2"],sheet.Range["C1"],true);
    
    wkBook.SaveAs("Sample.xlsx");
    wkBook.Close();

    Clear(Sparkline)

    Clears the sparkline.

    Declaration
    void Clear(Sparkline sparkline)
    Parameters
    Type Name Description
    Sparkline sparkline

    The sparkline range.IRange

    Examples

    The following example demonstrates the Clear Method

    ExcelEngine engine=new ExcelEngine();
    
    IApplication app= engine.Excel;
    
    app.DefaultVersion= ExcelVersion.Excel2010;
    
    IWorkbook wkBook= app.Workbooks.Create(2); 
    IWorksheet sheet= wkBook.Worksheets[0];
    
    ISparklineGroup spGroup= sheet.SparklineGroups.Add();
    
    //Initialize the Saprklines
    ISparklines sparklines=spGroup.Add(); 
    
    //Clears the Sparkline from the specified range.
    sparklines.Clear(sparklines[0] as Sparkline);
    
    wkBook.SaveAs("Sample.xlsx");
    wkBook.Close();

    RefreshRanges(IRange, IRange)

    Adds the sparkline.

    Declaration
    void RefreshRanges(IRange dataRange, IRange referenceRange)
    Parameters
    Type Name Description
    IRange dataRange

    The data range.IRange

    IRange referenceRange

    The reference range.IRange

    Examples

    The following example demonstrates the Add method.

    ExcelEngine engine=new ExcelEngine();
    
    IApplication app= engine.Excel;
    
    app.DefaultVersion= ExcelVersion.Excel2010;
    
    IWorkbook wkBook= app.Workbooks.Create(2); 
    IWorksheet sheet= wkBook.Worksheets[0];
    
    ISparklineGroup spGroup= sheet.SparklineGroups[0];
    
    //Initialize the Sparklines
    ISparklines sparklines=spGroup[0]; 
    
    //Add the Sparklines data range and reference range.
    sparklines.RefreshRanges(sheet.Range["A1:B2"],sheet.Range["C1"]);
    
    wkBook.SaveAs("Sample.xlsx");
    wkBook.Close();

    RefreshRanges(IRange, IRange, Boolean)

    Adds the sparkline.

    Declaration
    void RefreshRanges(IRange dataRange, IRange referenceRange, bool isVertical)
    Parameters
    Type Name Description
    IRange dataRange

    The data range.IRange

    IRange referenceRange

    The reference range.IRange

    System.Boolean isVertical

    Specifies whether to plot the sparklines from the refreshed data range by row or by column.

    Examples

    The following example demonstrates the Add method.

    ExcelEngine engine=new ExcelEngine();
    
    IApplication app= engine.Excel;
    
    app.DefaultVersion= ExcelVersion.Excel2010;
    
    IWorkbook wkBook= app.Workbooks.Create(2); 
    IWorksheet sheet= wkBook.Worksheets[0];
    
    ISparklineGroup spGroup= sheet.SparklineGroups[0];
    
    //Initialize the Sparklines
    ISparklines sparklines=spGroup[0]; 
    
    //Add the Sparklines data range and reference range.
    sparklines.RefreshRanges(sheet.Range["A1:B2"],sheet.Range["C1"],true);
    
    wkBook.SaveAs("Sample.xlsx");
    wkBook.Close();
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved