chartsheet-ag凯发旗舰厅

overview

package

class

tree

deprecated

index

help

prev class next class

frames no frames

summary: nested | field | constr | method

detail: field | constr | method

com.spire.xls
class chartsheet

java.lang.object
  com.spire.xls.core.spreadsheet.xlsobject
      com.spire.xls.core.spreadsheet.xlsworksheetbase
          com.spire.xls.core.spreadsheet.charts.xlschart
              com.spire.xls.chartsheet

all implemented interfaces:: ichart

public class chartsheet
extends xlschart
extends xlschart

constructor summary
`chartsheet(java.lang.object parent)`

method summary
`workbook`	`getbook()` workbook which contains the chart.
`chartarea`	`getchartarea()` returns an object that represents the complete chart area for the chart.
`charttextarea`	`getcharttitlearea()` gets title text area.
`commentscollection`	`getcomments()` represents comments collection for the worksheet.
`cellrange`	`getdatarange()` data range for the chart series.
`chartdatatable`	`getdatatable()` returns a data table object that represents the chart data table.
`chartwallorfloor`	`getfloor()` returns a floor object that represents the floor of the 3-d chart
`chartlegend`	`getlegend()` represents chart legend.
`chartpagesetup`	`getpagesetup()` page setup for the chart.
`chartplotarea`	`getplotarea()` returns a plot area object that represents the plot area of a chart.
`chartcategoryaxis`	`getprimarycategoryaxis()` returns primary category axis.
`chartseriesaxis`	`getprimaryserieaxis()` returns primary series axis.
`chartvalueaxis`	`getprimaryvalueaxis()` returns primary value axis.
`chartcategoryaxis`	`getsecondarycategoryaxis()` returns secondary category axis.
`chartvalueaxis`	`getsecondaryvalueaxis()` returns secondary value axis.
`chartseries`	`getseries()` returns an object that represents either a single series (a series object) or a collection of all the series (a series collection collection) in the chart or chart group.
`chartwallorfloor`	`getwalls()` represents chart walls.
`void`	`setdatarange(cellrange datarange)` data range for the chart series.
`void`	`tosvgstream(java.io.outputstream stream)` convert chart to svg stream

methods inherited from class com.spire.xls.core.spreadsheet.charts.xlschart
canchartbubblelabel, cancharthaveserieslines, canchartpercentagelabel, checkforsupportgridline, deepclone, deepclone, getautoscaling, getcategoryaxistitle, getchartstarttype, getcharttitle, getcharttitlefont, getcharttype, getdefaultlinepattern, getdepthpercent, getdestinationtype, getdisplayaxisfieldbuttons, getdisplayblanksas, getdisplayentirefieldbuttons, getdisplaylegendfieldbuttons, getdisplayvaluefieldbuttons, getelevation, getfont, getgapdepth, getheight, getheightpercent, getneeddataformat, getneeddropbar, getneedmarkerformat, getnoplotarea, getperspective, getpivotcharttype, getpivottable, getplotvisibleonly, getrightangleaxes, getrotation, getsecondarycategoryaxistitle, getsecondaryvalueaxistitle, getseriesaxistitle, getseriesdatafromrange, getshowreportfilterfieldbuttons, getsizewithwindow, getstyle, getsupportwallsandfloor, getvalueaxistitle, getwallsandgridlines2d, getwidth, getxpos, getypos, getzoomtofit, haschartarea, haschartarea, hascharttitle, hasdatatable, hasdatatable, hasfloor, haslegend, haslegend, haspivottable, hasplotarea, hasplotarea, haswalls, iscategoryaxisavail, ischart_100, ischart3d, ischartbar, ischartbubble, ischartcone, ischartcylinder, ischartdoughnut, ischartexploded, ischartfloor, ischartline, ischartpie, ischartpyramid, ischartradar, ischartscatter, ischartsmoothedline, ischartstock, ischartverycolor, ischartvolume, ischartwalls, isclustered, isembeded, isperspective, ispivot3dchart, issecondaryaxes, issecondaryaxes, isserieslines, isspecialdatalabels, isstacked, isvalueaxisavail, setautoscaling, setcategoryaxistitle, setcharttitle, setcharttype, setdatarange, setdepthpercent, setdestinationtype, setdisplayaxisfieldbuttons, setdisplayblanksas, setdisplayentirefieldbuttons, setdisplaylegendfieldbuttons, setdisplayvaluefieldbuttons, setelevation, setgapdepth, setheight, setheightpercent, setperspective, setpivotcharttype, setpivottable, setplotvisibleonly, setrightangleaxes, setrotation, setsecondarycategoryaxistitle, setsecondaryvalueaxistitle, setseriesaxistitle, setseriesdatafromrange, setshowreportfilterfieldbuttons, setsizewithwindow, setstyle, settodefaultgridlines, setvalueaxistitle, setwallsandgridlines2d, setwidth, setxpos, setypos, setzoomtofit

methods inherited from class com.spire.xls.core.spreadsheet.charts.xlschart

canchartbubblelabel, cancharthaveserieslines, canchartpercentagelabel, checkforsupportgridline, deepclone, deepclone, getautoscaling, getcategoryaxistitle, getchartstarttype, getcharttitle, getcharttitlefont, getcharttype, getdefaultlinepattern, getdepthpercent, getdestinationtype, getdisplayaxisfieldbuttons, getdisplayblanksas, getdisplayentirefieldbuttons, getdisplaylegendfieldbuttons, getdisplayvaluefieldbuttons, getelevation, getfont, getgapdepth, getheight, getheightpercent, getneeddataformat, getneeddropbar, getneedmarkerformat, getnoplotarea, getperspective, getpivotcharttype, getpivottable, getplotvisibleonly, getrightangleaxes, getrotation, getsecondarycategoryaxistitle, getsecondaryvalueaxistitle, getseriesaxistitle, getseriesdatafromrange, getshowreportfilterfieldbuttons, getsizewithwindow, getstyle, getsupportwallsandfloor, getvalueaxistitle, getwallsandgridlines2d, getwidth, getxpos, getypos, getzoomtofit, haschartarea, haschartarea, hascharttitle, hasdatatable, hasdatatable, hasfloor, haslegend, haslegend, haspivottable, hasplotarea, hasplotarea, haswalls, iscategoryaxisavail, ischart_100, ischart3d, ischartbar, ischartbubble, ischartcone, ischartcylinder, ischartdoughnut, ischartexploded, ischartfloor, ischartline, ischartpie, ischartpyramid, ischartradar, ischartscatter, ischartsmoothedline, ischartstock, ischartverycolor, ischartvolume, ischartwalls, isclustered, isembeded, isperspective, ispivot3dchart, issecondaryaxes, issecondaryaxes, isserieslines, isspecialdatalabels, isstacked, isvalueaxisavail, setautoscaling, setcategoryaxistitle, setcharttitle, setcharttype, setdatarange, setdepthpercent, setdestinationtype, setdisplayaxisfieldbuttons, setdisplayblanksas, setdisplayentirefieldbuttons, setdisplaylegendfieldbuttons, setdisplayvaluefieldbuttons, setelevation, setgapdepth, setheight, setheightpercent, setperspective, setpivotcharttype, setpivottable, setplotvisibleonly, setrightangleaxes, setrotation, setsecondarycategoryaxistitle, setsecondaryvalueaxistitle, setseriesaxistitle, setseriesdatafromrange, setshowreportfilterfieldbuttons, setsizewithwindow, setstyle, settodefaultgridlines, setvalueaxistitle, setwallsandgridlines2d, setwidth, setxpos, setypos, setzoomtofit

methods inherited from class com.spire.xls.core.spreadsheet.xlsworksheetbase
activate, getarcshapes, getbuttonshapes, getcharts, getcheckboxes, getcodename, getcomboboxes, getdefaultgridlinecolor, getfirstcolumn, getfirstrow, getgridlinecolor, getgroupboxes, getheaderfootershapes, getindex, getlabelshapes, getlastcolumn, getlastrow, getleftvisiblecolumn, getlines, getlistboxes, getname, getovalshapes, getparentworkbook, getpictures, getprotectcontents, getprotectdrawingobjects, getprotection, getprotectscenarios, getprstgeomshapes, getradiobuttons, getrealindex, getrectangleshapes, getscrollbarshapes, getshapes, getsheetid, getspinnershapes, gettabcolor, gettabcolorobject, gettabknowncolor, gettextboxes, gettopvisiblerow, gettypedarcs, gettypedbuttons, gettypedcheckboxes, gettypedcomboboxes, gettypedgroupboxes, gettypedlabels, gettypedlines, gettypedlistboxes, gettypedovals, gettypedpictures, gettypedradiobuttons, gettypedrects, gettypedscollbars, gettypedspinners, gettypedtextboxes, getunknownvmlshapes, getvisibility, getvmlshapescount, getworkbook, getzoom, haspictures, hasvmlshapes, ispasswordprotected, isrighttoleft, isrighttoleft, isselected, protect, protect, select, selecttab, setchanged, setfirstcolumn, setfirstrow, setgridlinecolor, setindex, setleftvisiblecolumn, setname, setrealindex, settabcolor, settabknowncolor, settopvisiblerow, setunknownvmlshapes, setvisibility, setzoom, unprotect, unprotect, unselect, unselect

methods inherited from class com.spire.xls.core.spreadsheet.xlsworksheetbase

activate, getarcshapes, getbuttonshapes, getcharts, getcheckboxes, getcodename, getcomboboxes, getdefaultgridlinecolor, getfirstcolumn, getfirstrow, getgridlinecolor, getgroupboxes, getheaderfootershapes, getindex, getlabelshapes, getlastcolumn, getlastrow, getleftvisiblecolumn, getlines, getlistboxes, getname, getovalshapes, getparentworkbook, getpictures, getprotectcontents, getprotectdrawingobjects, getprotection, getprotectscenarios, getprstgeomshapes, getradiobuttons, getrealindex, getrectangleshapes, getscrollbarshapes, getshapes, getsheetid, getspinnershapes, gettabcolor, gettabcolorobject, gettabknowncolor, gettextboxes, gettopvisiblerow, gettypedarcs, gettypedbuttons, gettypedcheckboxes, gettypedcomboboxes, gettypedgroupboxes, gettypedlabels, gettypedlines, gettypedlistboxes, gettypedovals, gettypedpictures, gettypedradiobuttons, gettypedrects, gettypedscollbars, gettypedspinners, gettypedtextboxes, getunknownvmlshapes, getvisibility, getvmlshapescount, getworkbook, getzoom, haspictures, hasvmlshapes, ispasswordprotected, isrighttoleft, isrighttoleft, isselected, protect, protect, select, selecttab, setchanged, setfirstcolumn, setfirstrow, setgridlinecolor, setindex, setleftvisiblecolumn, setname, setrealindex, settabcolor, settabknowncolor, settopvisiblerow, setunknownvmlshapes, setvisibility, setzoom, unprotect, unprotect, unselect, unselect

methods inherited from class com.spire.xls.core.spreadsheet.xlsobject
`dispose`

methods inherited from interface com.spire.xls.core.ichart
`getheightfordouble, getname, getwidthfordouble`

constructor detail

chartsheet

public chartsheet(java.lang.object parent)

method detail

getseries

public chartseries getseries()

returns an object that represents either a single series (a series object) or a collection of all the series (a series collection collection) in the chart or chart group.

getcharttitlearea

public charttextarea getcharttitlearea()

gets title text area. read-only.

getchartarea

public chartarea getchartarea()

returns an object that represents the complete chart area for the chart.

specified by:: getchartarea in interface ichart
overrides:: getchartarea in class xlschart

getdatarange

public cellrange getdatarange()

data range for the chart series.

specified by:: getdatarange in interface ichart
overrides:: getdatarange in class xlschart

setdatarange

public void setdatarange(cellrange datarange)

data range for the chart series.

getdatatable

public chartdatatable getdatatable()

returns a data table object that represents the chart data table.

specified by:: getdatatable in interface ichart
overrides:: getdatatable in class xlschart

getfloor

public chartwallorfloor getfloor()

returns a floor object that represents the floor of the 3-d chart

specified by:: getfloor in interface ichart
overrides:: getfloor in class xlschart

getlegend

public chartlegend getlegend()

represents chart legend.

specified by:: getlegend in interface ichart
overrides:: getlegend in class xlschart

getpagesetup

public chartpagesetup getpagesetup()

page setup for the chart.

specified by:: getpagesetup in interface ichart
overrides:: getpagesetup in class xlschart

getplotarea

public chartplotarea getplotarea()

returns a plot area object that represents the plot area of a chart.

specified by:: getplotarea in interface ichart
overrides:: getplotarea in class xlschart

getprimarycategoryaxis

public chartcategoryaxis getprimarycategoryaxis()

returns primary category axis.

specified by:: getprimarycategoryaxis in interface ichart
overrides:: getprimarycategoryaxis in class xlschart

getprimaryvalueaxis

public chartvalueaxis getprimaryvalueaxis()

returns primary value axis.

specified by:: getprimaryvalueaxis in interface ichart
overrides:: getprimaryvalueaxis in class xlschart

getprimaryserieaxis

public chartseriesaxis getprimaryserieaxis()

returns primary series axis.

specified by:: getprimaryserieaxis in interface ichart
overrides:: getprimaryserieaxis in class xlschart

getsecondarycategoryaxis

public chartcategoryaxis getsecondarycategoryaxis()

returns secondary category axis.

specified by:: getsecondarycategoryaxis in interface ichart
overrides:: getsecondarycategoryaxis in class xlschart

getsecondaryvalueaxis

public chartvalueaxis getsecondaryvalueaxis()

returns secondary value axis.

specified by:: getsecondaryvalueaxis in interface ichart
overrides:: getsecondaryvalueaxis in class xlschart

getbook

public workbook getbook()

workbook which contains the chart.

getwalls

public chartwallorfloor getwalls()

represents chart walls.

specified by:: getwalls in interface ichart
overrides:: getwalls in class xlschart

getcomments

public commentscollection getcomments()

represents comments collection for the worksheet. read-only.

overrides:: getcomments in class xlsworksheetbase

tosvgstream

public void tosvgstream(java.io.outputstream stream)

convert chart to svg stream

parameters:: stream - stream.