Spread Windows Forms 15.0
FarPoint.Excel Assembly / FarPoint.Excel Namespace / IExcelXml3 Interface / ExcelAddSparklineGroup Method
Index of the sheet.
The color series.
The color negative.
The color axis.
The color markers.
The color first.
The color last.
The color high.
The color low.
The formula.
The manual max.
The manual min.
The line weight.
Index of the type.
if set to true [date axis].
The display empty cells as.
if set to true [markers].
if set to true [high].
if set to true [low].
if set to true [first].
if set to true [last].
if set to true [negative].
if set to true [display X axis].
if set to true [display hidden].
Type of the min axis.
Type of the max axis.
if set to true [right to left].


In This Topic
    ExcelAddSparklineGroup Method
    In This Topic
    Excels the add sparkline group.
    Syntax
    'Declaration
     
    
    Function ExcelAddSparklineGroup( _
       ByVal sheetIndex As Short, _
       ByVal colorSeries As Color, _
       ByVal colorNegative As Color, _
       ByVal colorAxis As Color, _
       ByVal colorMarkers As Color, _
       ByVal colorFirst As Color, _
       ByVal colorLast As Color, _
       ByVal colorHigh As Color, _
       ByVal colorLow As Color, _
       ByVal formula As String, _
       ByVal manualMax As Double, _
       ByVal manualMin As Double, _
       ByVal lineWeight As Double, _
       ByVal typeIndex As Short, _
       ByVal dateAxis As Boolean, _
       ByVal displayEmptyCellsAs As Short, _
       ByVal markers As Boolean, _
       ByVal high As Boolean, _
       ByVal low As Boolean, _
       ByVal first As Boolean, _
       ByVal last As Boolean, _
       ByVal negative As Boolean, _
       ByVal displayXAxis As Boolean, _
       ByVal displayHidden As Boolean, _
       ByVal minAxisType As Short, _
       ByVal maxAxisType As Short, _
       ByVal rightToLeft As Boolean _
    ) As Boolean
    'Usage
     
    
    Dim instance As IExcelXml3
    Dim sheetIndex As Short
    Dim colorSeries As Color
    Dim colorNegative As Color
    Dim colorAxis As Color
    Dim colorMarkers As Color
    Dim colorFirst As Color
    Dim colorLast As Color
    Dim colorHigh As Color
    Dim colorLow As Color
    Dim formula As String
    Dim manualMax As Double
    Dim manualMin As Double
    Dim lineWeight As Double
    Dim typeIndex As Short
    Dim dateAxis As Boolean
    Dim displayEmptyCellsAs As Short
    Dim markers As Boolean
    Dim high As Boolean
    Dim low As Boolean
    Dim first As Boolean
    Dim last As Boolean
    Dim negative As Boolean
    Dim displayXAxis As Boolean
    Dim displayHidden As Boolean
    Dim minAxisType As Short
    Dim maxAxisType As Short
    Dim rightToLeft As Boolean
    Dim value As Boolean
     
    value = instance.ExcelAddSparklineGroup(sheetIndex, colorSeries, colorNegative, colorAxis, colorMarkers, colorFirst, colorLast, colorHigh, colorLow, formula, manualMax, manualMin, lineWeight, typeIndex, dateAxis, displayEmptyCellsAs, markers, high, low, first, last, negative, displayXAxis, displayHidden, minAxisType, maxAxisType, rightToLeft)

    Parameters

    sheetIndex
    Index of the sheet.
    colorSeries
    The color series.
    colorNegative
    The color negative.
    colorAxis
    The color axis.
    colorMarkers
    The color markers.
    colorFirst
    The color first.
    colorLast
    The color last.
    colorHigh
    The color high.
    colorLow
    The color low.
    formula
    The formula.
    manualMax
    The manual max.
    manualMin
    The manual min.
    lineWeight
    The line weight.
    typeIndex
    Index of the type.
    dateAxis
    if set to true [date axis].
    displayEmptyCellsAs
    The display empty cells as.
    markers
    if set to true [markers].
    high
    if set to true [high].
    low
    if set to true [low].
    first
    if set to true [first].
    last
    if set to true [last].
    negative
    if set to true [negative].
    displayXAxis
    if set to true [display X axis].
    displayHidden
    if set to true [display hidden].
    minAxisType
    Type of the min axis.
    maxAxisType
    Type of the max axis.
    rightToLeft
    if set to true [right to left].
    See Also