Timeline

Inheritance: java.lang.Object

public class Timeline

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

Example

         Workbook book = new Workbook();
         Worksheet sheet = book.getWorksheets().get(0);
         Cells cells = sheet.getCells();
         cells.get(0, 0).setValue("fruit");
         cells.get(1, 0).setValue("grape");
         cells.get(2, 0).setValue("blueberry");
         cells.get(3, 0).setValue("kiwi");
         cells.get(4, 0).setValue("cherry");
 
         //Create date style
         Style dateStyle = new CellsFactory().createStyle();
         dateStyle.setCustom("m/d/yyyy");
         cells.get(0, 1).setValue("date");
         cells.get(1, 1).setValue(new DateTime(2021, 2, 5));
         cells.get(2, 1).setValue(new DateTime(2022, 3, 8));
         cells.get(3, 1).setValue(new DateTime(2023, 4, 10));
         cells.get(4, 1).setValue(new DateTime(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).setValue("amount");
         cells.get(1, 2).setValue(50);
         cells.get(2, 2).setValue(60);
         cells.get(3, 2).setValue(70);
         cells.get(4, 2).setValue(80);
 
         PivotTableCollection pivots = sheet.getPivotTables();
         //Add a PivotTable
         int pivotIndex = pivots.add("=Sheet1!A1:C5", "A12", "TestPivotTable");
         PivotTable pivot = pivots.get(pivotIndex);
         pivot.addFieldToArea(PivotFieldType.ROW, "fruit");
         pivot.addFieldToArea(PivotFieldType.COLUMN, "date");
         pivot.addFieldToArea(PivotFieldType.DATA, "amount");
         pivot.setPivotTableStyleType(PivotTableStyleType.PIVOT_TABLE_STYLE_MEDIUM_10);
 
         //Refresh PivotTable data
         pivot.refreshData();
         pivot.calculateData();
 
         //Add a new Timeline using PivotTable as data source
         sheet.getTimelines().add(pivot, 10, 5, "date");
 
         //Get Timeline object
         Timeline timelineObj = sheet.getTimelines().get(0);
 
         //do your business
 
         book.save("out.xlsx");

Methods

Method	Description
equals(Object arg0)
getCaption()	Returns or sets the caption of the specified Timeline.
getClass()
getHeightPixel()	Returns or sets the height of the specified timeline, in pixels.
getLeftPixel()	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
getShape()	Returns the TimelineShape object associated with this Timeline.
getTopPixel()	Returns or sets the vertical offset of timeline shape from its top row, in pixels.
getWidthPixel()	Returns or sets the width of the specified timeline, in pixels.
hashCode()
notify()
notifyAll()
setCaption(String value)	Returns or sets the caption of the specified Timeline.
setHeightPixel(int value)	Returns or sets the height of the specified timeline, in pixels.
setLeftPixel(int value)	Returns or sets the horizontal offset of timeline shape from its left column, in pixels.
setName(String value)	Returns or sets the name of the specified Timeline
setTopPixel(int value)	Returns or sets the vertical offset of timeline shape from its top row, in pixels.
setWidthPixel(int value)	Returns or sets the width of the specified timeline, in pixels.
toString()
wait()
wait(long arg0)
wait(long arg0, int arg1)

equals(Object arg0)

public boolean equals(Object arg0)

Parameters:

Parameter	Type	Description
arg0	java.lang.Object

Returns: boolean

getCaption()

public String getCaption()

Returns or sets the caption of the specified Timeline.

Example

         //Set the caption of the specified Timeline.
         timelineObj.setCaption("timeline caption test");

Returns: java.lang.String

getClass()

public final native Class<?> getClass()

Returns: java.lang.Class

getHeightPixel()

public int getHeightPixel()

Returns or sets the height of the specified timeline, in pixels.

Remarks

NOTE: This member is now obsolete. Instead, please use Shape.Height property. This property will be removed 12 months later since May 2025. Aspose apologizes for any inconvenience you may have experienced.

Returns: int

getLeftPixel()

public int getLeftPixel()

Returns or sets the horizontal offset of timeline shape from its left column, in pixels.

Remarks

NOTE: This member is now obsolete. Instead, please use Shape.Left property. This property will be removed 12 months later since May 2025. Aspose apologizes for any inconvenience you may have experienced.

Returns: int

getName()

public String getName()

Returns or sets the name of the specified Timeline

Example

         //Set the name of the specified Timeline.
         timelineObj.setName("timeline name test");

Returns: java.lang.String

getShape()

public TimelineShape getShape()

Returns the TimelineShape object associated with this Timeline. Read-only.

Returns: TimelineShape

getTopPixel()

public int getTopPixel()

Returns or sets the vertical offset of timeline shape from its top row, in pixels.

Remarks

NOTE: This member is now obsolete. Instead, please use Shape.Top property. This property will be removed 12 months later since May 2025. Aspose apologizes for any inconvenience you may have experienced.

Returns: int

getWidthPixel()

public int getWidthPixel()

Returns or sets the width of the specified timeline, in pixels.

Remarks

NOTE: This member is now obsolete. Instead, please use Shape.Width property. This property will be removed 12 months later since May 2025. Aspose apologizes for any inconvenience you may have experienced.

Returns: int

hashCode()

public native int hashCode()

Returns: int

notify()

public final native void notify()

notifyAll()

public final native void notifyAll()

setCaption(String value)

public void setCaption(String value)

Returns or sets the caption of the specified Timeline.

Parameters:

Parameter	Type	Description
value	java.lang.String

setHeightPixel(int value)

public void setHeightPixel(int value)

Returns or sets the height of the specified timeline, in pixels.

Remarks

NOTE: This member is now obsolete. Instead, please use Shape.Height property. This property will be removed 12 months later since May 2025. Aspose apologizes for any inconvenience you may have experienced.

Parameters:

Parameter	Type	Description
value	int

setLeftPixel(int value)

public void setLeftPixel(int value)

Returns or sets the horizontal offset of timeline shape from its left column, in pixels.

Remarks

NOTE: This member is now obsolete. Instead, please use Shape.Left property. This property will be removed 12 months later since May 2025. Aspose apologizes for any inconvenience you may have experienced.

Parameters:

Parameter	Type	Description
value	int

setName(String value)

public void setName(String value)

Returns or sets the name of the specified Timeline

Parameters:

Parameter	Type	Description
value	java.lang.String

setTopPixel(int value)

public void setTopPixel(int value)

Returns or sets the vertical offset of timeline shape from its top row, in pixels.

Remarks

NOTE: This member is now obsolete. Instead, please use Shape.Top property. This property will be removed 12 months later since May 2025. Aspose apologizes for any inconvenience you may have experienced.

Parameters:

Parameter	Type	Description
value	int

setWidthPixel(int value)

public void setWidthPixel(int value)

Returns or sets the width of the specified timeline, in pixels.

Remarks

NOTE: This member is now obsolete. Instead, please use Shape.Width property. This property will be removed 12 months later since May 2025. Aspose apologizes for any inconvenience you may have experienced.

Parameters:

Parameter	Type	Description
value	int

toString()

public String toString()

Returns: java.lang.String

wait()

public final void wait()

wait(long arg0)

public final native void wait(long arg0)

Parameters:

Parameter	Type	Description
arg0	long

wait(long arg0, int arg1)

public final void wait(long arg0, int arg1)

Parameters:

Parameter	Type	Description
arg0	long
arg1	int