ws.sparklines

add(
    cell: { row: number; col: number },
    dataRange: CellRange,
    type: SparklineType,
    options?: CreateSparklineOptions,
  ): Promise<Sparkline>;

Add a sparkline to a cell. @param cell - Cell position (row and col, 0-based) @param dataRange - Data range for the sparkline @param type - Sparkline type (line, column, winLoss) @param options - Optional creation settings @returns The created sparkline

addGroup(
    cells: Array<{ row: number; col: number }>,
    dataRanges: CellRange[],
    type: SparklineType,
    options?: CreateSparklineGroupOptions,
  ): Promise<SparklineGroup>;

Add a group of sparklines with shared settings. @param cells - Array of cell positions @param dataRanges - Array of data ranges (must match cells length) @param type - Sparkline type @param options - Optional group creation settings @returns The created sparkline group

get(sparklineId: string): Promise<Sparkline | null>;

Get a sparkline by ID. @param sparklineId - Sparkline identifier @returns The sparkline, or null if not found

getAtCell(row: number, col: number): Promise<Sparkline | null>;

Get the sparkline at a specific cell. @param row - Row index (0-based) @param col - Column index (0-based) @returns The sparkline at the cell, or null if none

list(): Promise<Sparkline[]>;

List all sparklines in the worksheet. @returns Array of all sparklines

getGroup(groupId: string): Promise<SparklineGroup | null>;

Get a sparkline group by ID. @param groupId - Group identifier @returns The sparkline group, or null if not found

listGroups(): Promise<SparklineGroup[]>;

List all sparkline groups in the worksheet. @returns Array of all sparkline groups

update(sparklineId: string, updates: Partial<Sparkline>): Promise<void>;

Update a sparkline's settings. @param sparklineId - Sparkline identifier @param updates - Partial sparkline properties to update

updateGroup(groupId: string, updates: Partial<SparklineGroup>): Promise<void>;

Update a sparkline group's settings (applies to all members). @param groupId - Group identifier @param updates - Partial group properties to update

remove(sparklineId: string): Promise<void>;

Remove a sparkline. @param sparklineId - Sparkline identifier

removeGroup(groupId: string): Promise<void>;

Remove a sparkline group and all its member sparklines. @param groupId - Group identifier

clearInRange(range: CellRange): Promise<void>;

Clear all sparklines whose cell falls within a range. @param range - Range to clear sparklines from

clearAll(): Promise<void>;

Clear all sparklines in the worksheet.

addToGroup(sparklineId: string, groupId: string): Promise<void>;

Add a sparkline to a group. @param sparklineId - Sparkline identifier @param groupId - Group identifier

removeFromGroup(sparklineId: string): Promise<void>;

Remove a sparkline from its group (becomes standalone). @param sparklineId - Sparkline identifier

ungroupAll(groupId: string): Promise<string[]>;

Ungroup all sparklines in a group (members become standalone). @param groupId - Group identifier @returns IDs of sparklines that were ungrouped

has(row: number, col: number): Promise<boolean>;

Check if a cell has a sparkline. @param row - Row index (0-based) @param col - Column index (0-based) @returns True if the cell has a sparkline

getWithDataInRange(range: CellRange): Promise<Sparkline[]>;

Get sparklines whose data range intersects with a given range. @param range - Range to check for data intersection @returns Sparklines with data in the range