SparklineGroup class Worksheet

A group of Sparklines that share one type and colour scheme, the unit Excel stores sparklines in.

Add one with Sheet.addSparklineGroup (or the Sheet.addSparkline convenience for a single sparkline). Groups in an opened file are read back on Sheet.sparklineGroups and round-trip.

sheet.addSparklineGroup(SparklineGroup(
  type: SparklineType.column,
  color: ExcelColor.fromHexString('FF2962FF'),
  sparklines: [
    Sparkline(dataRange: 'B2:G2', location: 'H2'),
    Sparkline(dataRange: 'B3:G3', location: 'H3'),
  ],
));

Constructors

SparklineGroup({SparklineType type = SparklineType.line, ExcelColor? color, ExcelColor? negativeColor, ExcelColor? markerColor, ExcelColor? highColor, ExcelColor? lowColor, ExcelColor? firstColor, ExcelColor? lastColor, bool markers = false, bool high = false, bool low = false, bool first = false, bool last = false, bool negative = false, double? lineWeight, List<Sparkline>? sparklines})
Creates a sparkline group. color defaults to Excel's standard sparkline blue; sparklines may be provided up front or added later.

Properties

color → ExcelColor
The main series colour (OOXML colorSeries).
final
first → bool
Whether to highlight the first point.
final
firstColor → ExcelColor?
Colour of the first point (shown when first is set).
final
hashCode → int
The hash code for this object.
no setterinherited
high → bool
Whether to highlight the highest point.
final
highColor → ExcelColor?
Colour of the highest point (shown when high is set).
final
last → bool
Whether to highlight the last point.
final
lastColor → ExcelColor?
Colour of the last point (shown when last is set).
final
lineWeight → double?
The line weight in points (line sparklines), or null for the default.
final
low → bool
Whether to highlight the lowest point.
final
lowColor → ExcelColor?
Colour of the lowest point (shown when low is set).
final
markerColor → ExcelColor?
Colour of the markers (line sparklines, shown when markers is set).
final
markers → bool
Whether to show markers on each point (line sparklines).
final
negative → bool
Whether to highlight negative points.
final
negativeColor → ExcelColor?
Colour of negative points/columns (shown when negative is set).
final
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited
sparklines → List<Sparkline>
The sparklines in this group.
final
type → SparklineType
The sparkline chart type.
final

Methods

noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
toString() → String
A string representation of this object.
inherited

Operators

operator ==(Object other) → bool
The equality operator.
inherited