Aspose::Cells::Timelines::Timeline class

Timeline class

Summary description of Timeline View Due to MS Excel, Excel 2003 does not support Timeline.

class Timeline

Methods

MethodDescription
GetCaption()Gets or sets the caption of this Timeline.
GetCurrentLevel()The current time level of the Timeline.
GetHeightPixel()(Deprecated) Returns or sets the height of the specified timeline, in pixels.
GetLeftPixel()(Deprecated) Returns or sets the horizontal offset of timeline shape from its left column, in pixels.
GetName()Returns or sets the name of the specified Timeline.
GetSelectionLevel()Gets and sets the time level at which the current selection was made for the Timeline.
GetShape()Returns the TimelineShape object associated with this Timeline.
GetShowHeader()Indicates whether to display the header.
GetShowHorizontalScrollbar()Indicates whether to display the horizontal ccroll bar.
GetShowSelectionLabel()Indicates whether to display the selction label.
GetShowTimeLevel()Indicates whether to display the time level.
GetStartDate()Gets and sets the start date of the timespan scrolling position of this Timeline.
GetTopPixel()(Deprecated) Returns or sets the vertical offset of timeline shape from its top row, in pixels.
GetWidthPixel()(Deprecated) Returns or sets the width of the specified timeline, in pixels.
IsNull() constChecks whether the implementation object is nullptr.
explicit operator bool() constoperator bool()
operator=(const Timeline& src)operator=
SetCaption(const U16String& value)Gets or sets the caption of this Timeline.
SetCaption(const char16_t* value)Gets or sets the caption of this Timeline.
SetCurrentLevel(TimelineLevelType value)The current time level of the Timeline.
SetHeightPixel(int32_t value)(Deprecated) Returns or sets the height of the specified timeline, in pixels.
SetLeftPixel(int32_t value)(Deprecated) Returns or sets the horizontal offset of timeline shape from its left column, in pixels.
SetName(const U16String& value)Returns or sets the name of the specified Timeline.
SetName(const char16_t* value)Returns or sets the name of the specified Timeline.
SetSelectionLevel(TimelineLevelType value)Gets and sets the time level at which the current selection was made for the Timeline.
SetShowHeader(bool value)Indicates whether to display the header.
SetShowHorizontalScrollbar(bool value)Indicates whether to display the horizontal ccroll bar.
SetShowSelectionLabel(bool value)Indicates whether to display the selction label.
SetShowTimeLevel(bool value)Indicates whether to display the time level.
SetStartDate(const Date& value)Gets and sets the start date of the timespan scrolling position of this Timeline.
SetTopPixel(int32_t value)(Deprecated) Returns or sets the vertical offset of timeline shape from its top row, in pixels.
SetWidthPixel(int32_t value)(Deprecated) Returns or sets the width of the specified timeline, in pixels.
Timeline(Timeline_Impl* impl)Constructs from an implementation object.
Timeline(const Timeline& src)Copy constructor.
~Timeline()Destructor.

Fields

FieldDescription
_implThe implementation object.

Examples

Aspose::Cells::Startup();
Workbook book;
Worksheet sheet = book.GetWorksheets().Get(0);
Cells cells = sheet.GetCells();
cells.Get(0, 0).PutValue(u"fruit");
cells.Get(1, 0).PutValue(u"grape");
cells.Get(2, 0).PutValue(u"blueberry");
cells.Get(3, 0).PutValue(u"kiwi");
cells.Get(4, 0).PutValue(u"cherry");

//Create date style
Style dateStyle = CellsFactory().CreateStyle();
dateStyle.SetCustom(u"m/d/yyyy");
cells.Get(0, 1).PutValue(u"date");
cells.Get(1, 1).PutValue(Date{ 2021, 2, 5 });
cells.Get(2, 1).PutValue(Date{ 2022, 3, 8 });
cells.Get(3, 1).PutValue(Date{ 2023, 4, 10 });
cells.Get(4, 1).PutValue(Date{ 2024, 5, 16 });
//Set date style
cells.Get(1, 1).SetStyle(dateStyle);
cells.Get(2, 1).SetStyle(dateStyle);
cells.Get(3, 1).SetStyle(dateStyle);
cells.Get(4, 1).SetStyle(dateStyle);

cells.Get(0, 2).PutValue(u"amount");
cells.Get(1, 2).PutValue(50);
cells.Get(2, 2).PutValue(60);
cells.Get(3, 2).PutValue(70);
cells.Get(4, 2).PutValue(80);

PivotTableCollection pivots = sheet.GetPivotTables();
//Add a PivotTable
int pivotIndex = pivots.Add(u"=Sheet1!A1:C5", u"A12", u"TestPivotTable");
PivotTable pivot = pivots.Get(pivotIndex);
pivot.AddFieldToArea(PivotFieldType::Row, u"fruit");
pivot.AddFieldToArea(PivotFieldType::Column, u"date");
pivot.AddFieldToArea(PivotFieldType::Data, u"amount");
pivot.SetPivotTableStyleType(PivotTableStyleType::PivotTableStyleMedium10);

//Refresh PivotTable data
pivot.RefreshData();
pivot.CalculateData();

//Add a new Timeline using PivotTable as data source
sheet.GetTimelines().Add(pivot, 10, 5, u"date");

//Get Timeline object
Timeline timelineObj = sheet.GetTimelines().Get(0);


book.Save(u"out.xlsx");
Aspose::Cells::Cleanup();

See Also

Aspose::Cells::Timelines::TimelineCollection class