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 some Sparkline to the collection.
Add(SparklineType type, const char16_t* dataRange, bool isVertical, const CellArea& locationRange)	Adds an SparklineGroup with some Sparkline to the collection.
begin()	Returns an iterator to the beginning of the SparklineGroupCollection.
ClearSparklineGroups(const CellArea& cellArea)	Clears the sparkline groups that overlap an area of cells.
ClearSparklines(const CellArea& cellArea)	Clears the sparklines that are inside an area of cells.
end()	Returns an iterator to the end of the SparklineGroupCollection.
Get(int32_t index)	Gets the SparklineGroup element at the specified index.
GetCount()	Gets the number of elements contained in the instance.
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++