sparklinegroup-ag凯发旗舰厅

com.spire.xls
class sparklinegroup

java.lang.object
  java.util.abstractcollection
      java.util.abstractlist
          java.util.arraylist<isparklines>
              com.spire.xls.sparklinegroup

all implemented interfaces:

isparklinegroup, java.lang.iterable<isparklines>, java.util.collection<isparklines>, java.util.list<isparklines>

public class sparklinegroup
extends java.util.arraylist<isparklines>
implements isparklinegroup

represents a sparkline group.the sparkline group object is a member of the sparkline groups collection.the sparkline groups collection contains all the sparkline group objects in a workheet.

see also:

serialized form

sparklinegroup

public sparklinegroup(xlsworksheet sheet)

getshowhorizontalaxis

public boolean getshowhorizontalaxis()

indicates whether to show the sparkline horizontal axis. the horizontal axis appears if the sparkline has data that crosses the zero axis.

specified by:

getshowhorizontalaxis in interface isparklinegroup

setshowhorizontalaxis

public void setshowhorizontalaxis(boolean value)

sets whether to show the sparkline horizontal axis. the horizontal axis appears if the sparkline has data that crosses the zero axis.

specified by:

setshowhorizontalaxis in interface isparklinegroup

isdisplayhidden

public boolean isdisplayhidden()

indicates whether to show data in hidden rows and columns.

specified by:

isdisplayhidden in interface isparklinegroup

isdisplayhidden

public void isdisplayhidden(boolean value)

indicates whether to show data in hidden rows and columns.

specified by:

isdisplayhidden in interface isparklinegroup

getplotrighttoleft

public boolean getplotrighttoleft()

indicates whether the plot data is right to left.

specified by:

getplotrighttoleft in interface isparklinegroup

returns:

true if [plot right to left]; otherwise, false.

setplotrighttoleft

public void setplotrighttoleft(boolean bool)

sets whether the plot data is right to left.

specified by:

setplotrighttoleft in interface isparklinegroup

parameters:

bool - true if [plot right to left]; otherwise, false.

getshowfirstpoint

public boolean getshowfirstpoint()

indicates whether to highlight the first point of data in the sparkline group.

specified by:

getshowfirstpoint in interface isparklinegroup

setshowfirstpoint

public void setshowfirstpoint(boolean bool)

sets whether to highlight the first point of data in the sparkline group.

specified by:

setshowfirstpoint in interface isparklinegroup

getshowlastpoint

public boolean getshowlastpoint()

indicates whether to highlight the last point of data in the sparkline group.

specified by:

getshowlastpoint in interface isparklinegroup

setshowlastpoint

public void setshowlastpoint(boolean value)

sets whether to highlight the last point of data in the sparkline group.

specified by:

setshowlastpoint in interface isparklinegroup

getshowlowpoint

public boolean getshowlowpoint()

indicates whether to highlight the lowest points of data in the sparkline group.

specified by:

getshowlowpoint in interface isparklinegroup

setshowlowpoint

public void setshowlowpoint(boolean value)

sets whether to highlight the lowest points of data in the sparkline group.

specified by:

setshowlowpoint in interface isparklinegroup

getshowhighpoint

public boolean getshowhighpoint()

indicates whether to highlight the highest points of data in the sparkline group.

specified by:

getshowhighpoint in interface isparklinegroup

setshowhighpoint

public void setshowhighpoint(boolean value)

sets whether to highlight the highest points of data in the sparkline group.

specified by:

setshowhighpoint in interface isparklinegroup

getshownegativepoint

public boolean getshownegativepoint()

indicates whether to highlight the negative values on the sparkline group with a different color or marker.

specified by:

getshownegativepoint in interface isparklinegroup

setshownegativepoint

public void setshownegativepoint(boolean value)

sets whether to highlight the negative values on the sparkline group with a different color or marker.

specified by:

setshownegativepoint in interface isparklinegroup

getshowmarkers

public boolean getshowmarkers()

indicates whether to highlight each point in each line sparkline in the sparkline group.

specified by:

getshowmarkers in interface isparklinegroup

setshowmarkers

public void setshowmarkers(boolean value)

sets whether to highlight each point in each line sparkline in the sparkline group.

specified by:

setshowmarkers in interface isparklinegroup

getverticalaxismaxvalue

public double getverticalaxismaxvalue()

gets the custom maximum value for the vertical axis.

setverticalaxismaxvalue

public void setverticalaxismaxvalue(double value)

sets the custom maximum value for the vertical axis.

getverticalaxismaxtype

public  getverticalaxismaxtype()

represents the vertical axis maximum value type.

setverticalaxismaxtype

public void setverticalaxismaxtype( value)

sets the vertical axis maximum value type.

getverticalaxisminvalue

public double getverticalaxisminvalue()

gets and sets the custom minimum value for the vertical axis.

setverticalaxisminvalue

public void setverticalaxisminvalue(double value)

sets the custom minimum value for the vertical axis.

getverticalaxisminvaluetype

public  getverticalaxisminvaluetype()

represents the vertical axis minimum value type.

setverticalaxisminvaluetype

public void setverticalaxisminvaluetype( value)

represents the vertical axis minimum value type.

getsparklinetype

public sparklinetype getsparklinetype()

indicates the sparkline type of the sparkline group.

specified by:

getsparklinetype in interface isparklinegroup

setsparklinetype

public void setsparklinetype(sparklinetype value)

sets the sparkline type of the sparkline group.

specified by:

setsparklinetype in interface isparklinegroup

ishorizontaldateaxis

public boolean ishorizontaldateaxis()

indicates wheter represents the horizontal axis type as dateaxis.

specified by:

ishorizontaldateaxis in interface isparklinegroup

ishorizontaldateaxis

public void ishorizontaldateaxis(boolean value)

indicates wheter represents the horizontal axis type as dateaxis.

specified by:

ishorizontaldateaxis in interface isparklinegroup

getemptycellstype

public  getemptycellstype()

indicates how to display empty cells.

specified by:

getemptycellstype in interface isparklinegroup

setemptycellstype

public void setemptycellstype( sparklineemptycells)

indicates how to display empty cells.

specified by:

setemptycellstype in interface isparklinegroup

gethorizontaldateaxisrange

public cellrange gethorizontaldateaxisrange()

represents the range that contains the date values for the sparkline data.

specified by:

gethorizontaldateaxisrange in interface isparklinegroup

sethorizontaldateaxisrange

public void sethorizontaldateaxisrange(cellrange value)

represents the range that contains the date values for the sparkline data.

specified by:

sethorizontaldateaxisrange in interface isparklinegroup

gethorizontalaxiscolor

public java.awt.color gethorizontalaxiscolor()

gets the color of the horizontal axis in the sparkline group.

specified by:

gethorizontalaxiscolor in interface isparklinegroup

sethorizontalaxiscolor

public void sethorizontalaxiscolor(com.spire.ms.system.drawing.color value)

sets the color of the horizontal axis in the sparkline group.

specified by:

sethorizontalaxiscolor in interface isparklinegroup

getfirstpointcolor

public java.awt.color getfirstpointcolor()

gets the color of the first point of data in the sparkline group.

specified by:

getfirstpointcolor in interface isparklinegroup

setfirstpointcolor

public void setfirstpointcolor(com.spire.ms.system.drawing.color value)

sets the color of the first point of data in the sparkline group.

specified by:

setfirstpointcolor in interface isparklinegroup

gethighpointcolor

public java.awt.color gethighpointcolor()

gets the color of the highest points of data in the sparkline group.

specified by:

gethighpointcolor in interface isparklinegroup

sethighpointcolor

public void sethighpointcolor(com.spire.ms.system.drawing.color value)

sets the color of the highest points of data in the sparkline group.

specified by:

sethighpointcolor in interface isparklinegroup

getlastpointcolor

public java.awt.color getlastpointcolor()

gets the color of the last point of data in the sparkline group.

specified by:

getlastpointcolor in interface isparklinegroup

setlastpointcolor

public void setlastpointcolor(com.spire.ms.system.drawing.color value)

sets the color of the last point of data in the sparkline group.

specified by:

setlastpointcolor in interface isparklinegroup

getlineweight

public double getlineweight()

gets the line weight in each line sparkline in the sparkline group, in the unit of points.

specified by:

getlineweight in interface isparklinegroup

setlineweight

public void setlineweight(double value)

sets the line weight in each line sparkline in the sparkline group, in the unit of points.

specified by:

setlineweight in interface isparklinegroup

getlowpointcolor

public java.awt.color getlowpointcolor()

gets the color of the lowest points of data in the sparkline group.

specified by:

getlowpointcolor in interface isparklinegroup

setlowpointcolor

public void setlowpointcolor(com.spire.ms.system.drawing.color value)

sets the color of the lowest points of data in the sparkline group.

specified by:

setlowpointcolor in interface isparklinegroup

getmarkerscolor

public java.awt.color getmarkerscolor()

gets the color of points in each line sparkline in the sparkline group.

specified by:

getmarkerscolor in interface isparklinegroup

setmarkerscolor

public void setmarkerscolor(com.spire.ms.system.drawing.color value)

sets the color of points in each line sparkline in the sparkline group.

specified by:

setmarkerscolor in interface isparklinegroup

getnegativepointcolor

public java.awt.color getnegativepointcolor()

gets the color of the negative values on the sparkline group.

specified by:

getnegativepointcolor in interface isparklinegroup

setnegativepointcolor

public void setnegativepointcolor(com.spire.ms.system.drawing.color value)

sets the color of the negative values on the sparkline group.

specified by:

setnegativepointcolor in interface isparklinegroup

getsparklinecolor

public java.awt.color getsparklinecolor()

gets the color of the sparklines in the sparkline group.

specified by:

getsparklinecolor in interface isparklinegroup

setsparklinecolor

public void setsparklinecolor(java.awt.color color)

sets the color of the sparklines in the sparkline group.

specified by:

setsparklinecolor in interface isparklinegroup

add

public sparklinecollection add()

specified by:

add in interface isparklinegroup

get

public sparklinecollection get(int index)

overrides:

get in class java.util.arraylist<isparklines>