Aspose::Cells::Charts::SparklineGroupCollection class

SparklineGroupCollection class

Encapsulates a collection of SparklineGroup objects.

class SparklineGroupCollection

Methods

Method	Description
Add(SparklineType type)	Adds an SparklineGroup with a Sparkline to the collection.
Add(SparklineType type, const U16String& dataRange, bool isVertical, const CellArea& locationRange)	Adds an SparklineGroup with Sparkline to the collection.
Add(SparklineType type, const char16_t* dataRange, bool isVertical, const CellArea& locationRange)	Adds an SparklineGroup with Sparkline to the collection.
ClearSparklineGroups(const CellArea& cellArea)	Clears the sparkline groups that overlaps an area of cells.
ClearSparklines(const CellArea& cellArea)	Clears the sparklines that is inside an area of cells.
Get(int32_t index)	Gets the SparklineGroup element at the specified index.
GetCount()
IsNull() const	Checks whether the implementation object is nullptr.
explicit operator bool() const	operator bool()
operator=(const SparklineGroupCollection& src)	operator=
SparklineGroupCollection(SparklineGroupCollection_Impl* impl)	Constructs from an implementation object.
SparklineGroupCollection(const SparklineGroupCollection& src)	Copy constructor.
~SparklineGroupCollection()	Destructor.

Fields

Field	Description
_impl	The implementation object.

Examples

Aspose::Cells::Startup();
Workbook book;
Worksheet sheet = book.GetWorksheets().Get(0);

sheet.GetCells().Get(u"A1").PutValue(5);
sheet.GetCells().Get(u"B1").PutValue(2);
sheet.GetCells().Get(u"C1").PutValue(1);
sheet.GetCells().Get(u"D1").PutValue(3);

// Define the CellArea
CellArea ca;
ca.StartColumn = 4;
ca.EndColumn = 4;
ca.StartRow = 0;
ca.EndRow = 0;

int idx = sheet.GetSparklineGroups().Add(SparklineType::Line, u"A1:D1", false, ca);
SparklineGroup group = sheet.GetSparklineGroups().Get(idx);
group.GetSparklines().Add(sheet.GetName() + u"!A1:D1", 0, 4);
book.Save(u"output.xlsx", SaveFormat::Xlsx);
Aspose::Cells::Cleanup();

See Also

• Namespace Aspose::Cells::Charts
• Library Aspose.Cells for C++