Click or drag to resize

ExcelSparklineGroupsCollection Class

Represents the sparkline groups of a worksheet, returned by SparklineGroups. Sparklines are available only in the Excel 2007+ (.xlsx) format and are displayed by Excel 2010 and later; the Excel 97-2003 format cannot store them.
Inheritance Hierarchy
SystemObject
  ExpertXls.ExcelLibExcelSparklineGroupsCollection

Namespace: ExpertXls.ExcelLib
Assembly: expertxls (in expertxls.dll) Version: 10.0.0
Syntax
public class ExcelSparklineGroupsCollection : IEnumerable

The ExcelSparklineGroupsCollection type exposes the following members.

Properties
 NameDescription
Public propertyCount Gets the number of sparkline groups in the worksheet.
Public propertyItem Gets the sparkline group at the specified index.
Top
Methods
 NameDescription
Public methodAdd Adds a group of sparklines. The location range is a single row or a single column of cells and gets one sparkline in each cell: when the location is a column, each row of the data range is drawn in the cell of the same row; when the location is a row, each column of the data range is drawn in the cell of the same column. For example the data range "B2:M5" and the location range "N2:N5" draw the twelve months of each row in column N. Sparklines are available only in the Excel 2007+ (.xlsx) format.
Public methodClear Removes all the sparkline groups of the worksheet.
Public methodGetEnumerator Gets the collection enumerator
Public methodRemoveAt Removes the sparkline group at the specified index.
Top
See Also