TimelineCollection.Item

TimelineCollection indexer (1 of 2)

Gets the Timeline by index.

public Timeline this[int index] { get; }

Examples

using System;
using Aspose.Cells;
using Aspose.Cells.Timelines;
using Aspose.Cells.Pivot;

namespace AsposeCellsExamples
{
    public class TimelineCollectionPropertyItemDemo
    {
        public static void Run()
        {
            // Create a workbook
            Workbook workbook = new Workbook();
            
            // Access first worksheet
            Worksheet sheet = workbook.Worksheets[0];
            
            // Add sample data for pivot table
            sheet.Cells["A1"].PutValue("Date");
            sheet.Cells["A2"].PutValue(DateTime.Now);
            sheet.Cells["A3"].PutValue(DateTime.Now.AddDays(1));
            
            // Create pivot table first
            int pivotIndex = sheet.PivotTables.Add("A1:A3", "E3", "PivotTable1");
            PivotTable pivotTable = sheet.PivotTables[pivotIndex];
            
            // Add timeline to the worksheet
            int index = sheet.Timelines.Add(pivotTable, 0, 0, "Date");
            
            // Access timeline using Item property by index
            Timeline timelineByIndex = sheet.Timelines[index];
            
            // Demonstrate usage of the timeline
            Console.WriteLine("Timeline name: " + timelineByIndex.Name);
        }
    }
}

See Also

TimelineCollection indexer (2 of 2)

Gets the Timeline by Timeline’s name.

public Timeline this[string name] { get; }

Examples


[C#]

//Get the Timeline by Timeline's name.
Timeline objByName = sheet.Timelines["date"];

See Also