API Reference

Class

ExcelVisualSparkline

Namespace OfficeIMO.Excel
Assembly OfficeIMO.Excel
Modifiers sealed

Positioned worksheet sparkline metadata in an Excel range snapshot.

Inheritance

  • Object
  • ExcelVisualSparkline

Usage

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

Returned or exposed by

Properties

public Int32 Row { get; } #

One-based source row.

public Int32 Column { get; } #

One-based source column.

public Double X { get; } #

X position in CSS pixels.

public Double Y { get; } #

Y position in CSS pixels.

public Double Width { get; } #

Cell width in CSS pixels.

public Double Height { get; } #

Cell height in CSS pixels.

public String Kind { get; } #

Sparkline kind as authored in the worksheet metadata.

public IReadOnlyList<Double> Values { get; } #

Numeric values plotted by the sparkline.

public Boolean DisplayMarkers { get; } #

Whether point markers should be displayed.

public Boolean DisplayHigh { get; } #

Whether the high point should be highlighted.

public Boolean DisplayLow { get; } #

Whether the low point should be highlighted.

public Boolean DisplayFirst { get; } #

Whether the first point should be highlighted.

public Boolean DisplayLast { get; } #

Whether the last point should be highlighted.

public Boolean DisplayNegative { get; } #

Whether negative points should be highlighted.

public Boolean DisplayAxis { get; } #

Whether a zero axis should be displayed when the data crosses zero.

public String SeriesColorArgb { get; } #

Series color in ARGB hexadecimal form, when specified.

public String AxisColorArgb { get; } #

Axis color in ARGB hexadecimal form, when specified.

public String NegativeColorArgb { get; } #

Negative point color in ARGB hexadecimal form, when specified.

public String MarkersColorArgb { get; } #

Regular marker color in ARGB hexadecimal form, when specified.

public String HighColorArgb { get; } #

High point color in ARGB hexadecimal form, when specified.

public String LowColorArgb { get; } #

Low point color in ARGB hexadecimal form, when specified.

public String FirstColorArgb { get; } #

First point color in ARGB hexadecimal form, when specified.

public String LastColorArgb { get; } #

Last point color in ARGB hexadecimal form, when specified.

public Nullable<Double> ScaleMinimum { get; } #

Minimum value used to scale the rendered sparkline, usually resolved from its Excel group.

public Nullable<Double> ScaleMaximum { get; } #

Maximum value used to scale the rendered sparkline, usually resolved from its Excel group.

public String Source { get; } #

Source reference used by export diagnostics.