Interface IXLSparklineGroup

Namespace

SlapKit.Excel.Excel

Assembly

SlapKit.Excel.dll

public interface IXLSparklineGroup : IEnumerable<IXLSparkline>, IEnumerable

Inherited Members

IEnumerable<IXLSparkline>.GetEnumerator()

Extension Methods

AttributeExtensions.GetMethod<T>(T, Expression<Action<T>>)

AttributeExtensions.GetMethod<T>(T, Expression<Func<T, object>>)

Properties

DateRange

IXLRange DateRange { get; set; }

Property Value

IXLRange

DisplayEmptyCellsAs

XLDisplayBlanksAsValues DisplayEmptyCellsAs { get; set; }

Property Value

XLDisplayBlanksAsValues

DisplayHidden

bool DisplayHidden { get; set; }

Property Value

bool

HorizontalAxis

IXLSparklineHorizontalAxis HorizontalAxis { get; }

Property Value

IXLSparklineHorizontalAxis

LineWeight

double LineWeight { get; set; }

Property Value

double

ShowMarkers

XLSparklineMarkers ShowMarkers { get; set; }

Property Value

XLSparklineMarkers

Style

IXLSparklineStyle Style { get; set; }

Property Value

IXLSparklineStyle

Type

XLSparklineType Type { get; set; }

Property Value

XLSparklineType

VerticalAxis

IXLSparklineVerticalAxis VerticalAxis { get; }

Property Value

IXLSparklineVerticalAxis

Worksheet

IXLWorksheet Worksheet { get; }

Property Value

IXLWorksheet

Methods

Add(IXLCell, IXLRange)

IXLSparkline Add(IXLCell location, IXLRange sourceData)

Parameters

location IXLCell

sourceData IXLRange

Returns

IXLSparkline

Add(IXLRange, IXLRange)

IEnumerable<IXLSparkline> Add(IXLRange locationRange, IXLRange sourceDataRange)

Parameters

locationRange IXLRange

sourceDataRange IXLRange

Returns

IEnumerable<IXLSparkline>

Add(string, string)

IEnumerable<IXLSparkline> Add(string locationRangeAddress, string sourceDataAddress)

Parameters

locationRangeAddress string

sourceDataAddress string

Returns

IEnumerable<IXLSparkline>

CopyFrom(IXLSparklineGroup)

void CopyFrom(IXLSparklineGroup sparklineGroup)

Parameters

sparklineGroup IXLSparklineGroup

CopyTo(IXLWorksheet)

IXLSparklineGroup CopyTo(IXLWorksheet targetSheet)

Parameters

targetSheet IXLWorksheet

Returns

IXLSparklineGroup

GetSparkline(IXLCell)

IXLSparkline GetSparkline(IXLCell cell)

Parameters

cell IXLCell

Returns

IXLSparkline

GetSparklines(IXLRangeBase)

IEnumerable<IXLSparkline> GetSparklines(IXLRangeBase searchRange)

Parameters

searchRange IXLRangeBase

Returns

IEnumerable<IXLSparkline>

Remove(IXLCell)

void Remove(IXLCell cell)

Parameters

cell IXLCell

Remove(IXLSparkline)

void Remove(IXLSparkline sparkline)

Parameters

sparkline IXLSparkline

RemoveAll()

void RemoveAll()

SetDateRange(IXLRange)

IXLSparklineGroup SetDateRange(IXLRange value)

Parameters

value IXLRange

Returns

IXLSparklineGroup

SetDisplayEmptyCellsAs(XLDisplayBlanksAsValues)

IXLSparklineGroup SetDisplayEmptyCellsAs(XLDisplayBlanksAsValues value)

Parameters

value XLDisplayBlanksAsValues

Returns

IXLSparklineGroup

SetDisplayHidden(bool)

IXLSparklineGroup SetDisplayHidden(bool value)

Parameters

value bool

Returns

IXLSparklineGroup

SetLineWeight(double)

IXLSparklineGroup SetLineWeight(double value)

Parameters

value double

Returns

IXLSparklineGroup

SetShowMarkers(XLSparklineMarkers)

IXLSparklineGroup SetShowMarkers(XLSparklineMarkers value)

Parameters

value XLSparklineMarkers

Returns

IXLSparklineGroup

SetStyle(IXLSparklineStyle)

IXLSparklineGroup SetStyle(IXLSparklineStyle value)

Parameters

value IXLSparklineStyle

Returns

IXLSparklineGroup

SetType(XLSparklineType)

IXLSparklineGroup SetType(XLSparklineType value)

Parameters

value XLSparklineType

Returns

IXLSparklineGroup