Get Started

API Reference

Class

SparklineBuilder

Edit on GitHub
Namespace OfficeIMO.Excel.Fluent
Assembly OfficeIMO.Excel
Source OfficeIMO.Excel/Fluent/SparklineBuilder.cs:34
Modifiers sealed

Fluent builder for worksheet sparklines.

Inheritance

  • Object
  • SparklineBuilder

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

Methods

public ExcelSheet At(String locationRange) #
OfficeIMO.Excel/Fluent/SparklineBuilder.cs:106
Returns: ExcelSheet

Creates the sparklines at the given location range.

Parameters

locationRange System.String requiredposition: 0
public SparklineBuilder Axis(Boolean show = true) #
OfficeIMO.Excel/Fluent/SparklineBuilder.cs:73
Returns: SparklineBuilder

Shows or hides the horizontal axis.

Parameters

show System.Boolean = true optionalposition: 0
public SparklineBuilder Color(String color) #
OfficeIMO.Excel/Fluent/SparklineBuilder.cs:79
Returns: SparklineBuilder

Sets the main sparkline series color.

Parameters

color System.String requiredposition: 0
public SparklineBuilder Colors(String series = null, String axis = null, String negative = null, String markers = null, String high = null, String low = null, String first = null, String last = null) #
OfficeIMO.Excel/Fluent/SparklineBuilder.cs:93
Returns: SparklineBuilder

Sets optional sparkline colors.

Parameters

series System.String = null optionalposition: 0
axis System.String = null optionalposition: 1
negative System.String = null optionalposition: 2
markers System.String = null optionalposition: 3
high System.String = null optionalposition: 4
low System.String = null optionalposition: 5
first System.String = null optionalposition: 6
last System.String = null optionalposition: 7
public SparklineBuilder Column() #
OfficeIMO.Excel/Fluent/SparklineBuilder.cs:42
Returns: SparklineBuilder

Uses column sparklines.

public SparklineBuilder FirstLast(Boolean show = true) #
OfficeIMO.Excel/Fluent/SparklineBuilder.cs:61
Returns: SparklineBuilder

Shows or hides first and last point markers.

Parameters

show System.Boolean = true optionalposition: 0
public SparklineBuilder HighLow(Boolean show = true) #
OfficeIMO.Excel/Fluent/SparklineBuilder.cs:55
Returns: SparklineBuilder

Shows or hides high and low point markers.

Parameters

show System.Boolean = true optionalposition: 0
public SparklineBuilder Line() #
OfficeIMO.Excel/Fluent/SparklineBuilder.cs:39
Returns: SparklineBuilder

Uses line sparklines.

public SparklineBuilder Markers(Boolean show = true) #
OfficeIMO.Excel/Fluent/SparklineBuilder.cs:49
Returns: SparklineBuilder

Shows or hides point markers.

Parameters

show System.Boolean = true optionalposition: 0
public SparklineBuilder Negative(Boolean show = true) #
OfficeIMO.Excel/Fluent/SparklineBuilder.cs:67
Returns: SparklineBuilder

Shows or hides negative point markers.

Parameters

show System.Boolean = true optionalposition: 0
public SparklineBuilder Type(SparklineTypeValues type) #
OfficeIMO.Excel/Fluent/SparklineBuilder.cs:34
Returns: SparklineBuilder

Uses a specific sparkline type.

Parameters

type DocumentFormat.OpenXml.Office2010.Excel.SparklineTypeValues requiredposition: 0
public SparklineBuilder WinLoss() #
OfficeIMO.Excel/Fluent/SparklineBuilder.cs:45
Returns: SparklineBuilder

Uses win/loss sparklines.