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

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.XlsWorksheetBase

activate, getArcShapes, getCharts, getCheckBoxes, getCodeName, getComboBoxes, getDefaultGridlineColor, getFirstColumn, getFirstRow, getGridLineColor, getGroupBoxes, getHeaderFooterShapes, getIndex, getLastColumn, getLastRow, getLeftVisibleColumn, getName, getOvalShapes, getParentWorkbook, getPictures, getProtectContents, getProtectDrawingObjects, getProtection, getProtectScenarios, getPrstGeomShapes, getRadioButtons, getRealIndex, getRectangleShapes, getScrollBarShapes, getShapes, getSheetId, getSpinnerShapes, getTabColor, getTabColorObject, getTabKnownColor, getTextBoxes, getTopVisibleRow, getTypedCheckBoxes, getTypedComboBoxes, getTypedLines, getTypedPictures, getTypedTextBoxes, getUnknownVmlShapes, getVisibility, getVmlShapesCount, getWorkbook, getZoom, hasPictures, hasVmlShapes, isPasswordProtected, isRightToLeft, isRightToLeft, isSelected, protect, protect, select, selectTab, setChanged, 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.