Aspose::Cells::Charts::SparklineGroupCollection class
Contents
[
Hide
]SparklineGroupCollection class
Encapsulates a collection of SparklineGroup objects.
class SparklineGroupCollection
Methods
| Method | Description |
|---|---|
| Add(SparklineType type, const U16String& dataRange, bool isVertical, const CellArea& locationRange) | Adds an SparklineGroup item to the collection. |
| Add(SparklineType type, const char16_t* dataRange, bool isVertical, const CellArea& locationRange) | Adds an SparklineGroup item 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++