asposecells.api

Classes

Constants

Class Chart

Encapsulates the object that represents a single Excel chart.

Example:

workbook = Workbook()
sheet = workbook.getWorksheets().get(0)
cells = sheet.getCells()
cells.get(0, 1).putValue("Income")
cells.get(1, 0).putValue("Company A")
cells.get(2, 0).putValue("Company B")
cells.get(3, 0).putValue("Company C")
cells.get(1, 1).putValue(10000)
cells.get(2, 1).putValue(20000)
cells.get(3, 1).putValue(30000)
chartIndex = sheet.getCharts().add(ChartType.COLUMN, 9, 9, 21, 15)
chart = sheet.getCharts().get(chartIndex)
chart.getNSeries().add("B2:B4", True)
chart.getNSeries().setCategoryData("A2:A4")
aSeries = chart.getNSeries().get(0)
aSeries.setName("=B1")
chart.setShowLegend(True)
chart.getTitle().setText("Income Analysis")

Property Getters/Setters Summary
`method`	`getActualChartSize()`
	Gets actual size of chart
`method`	`getAutoScaling()`
`method`	`setAutoScaling(value)`
	True if Microsoft Excel scales a 3-D chart so that it's closer in size to the equivalent 2-D chart. The RightAngleAxes property must be True.
`method`	`getBackWall()`
	Returns a Walls object that represents the back wall of a 3-D chart.
`method`	`getCategoryAxis()`
	Gets the chart's X axis.
`method`	`getChartArea()`
	Gets the chart area in the worksheet
`method`	`getChartDataTable()`
	Represents the chart data table.
`method`	`getChartObject()`
	Represents the chartShape;
`method`	`getChartShape()`
	Represents the chartShape;
`method`	`getDepthPercent()`
`method`	`setDepthPercent(value)`
	Represents the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).
`method`	`getDisplayNaAsBlank()`
`method`	`setDisplayNaAsBlank(value)`
	Indicates whether displaying #N/A as blank value.
`method`	`getElevation()`
`method`	`setElevation(value)`
	Represents the elevation of the 3-D chart view, in degrees.
`method`	`getFirstSliceAngle()`
`method`	`setFirstSliceAngle(value)`
	Gets or sets the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical). Applies only to pie, 3-D pie, and doughnut charts, 0 to 360.
`method`	`getFloor()`
	Returns a Floor object that represents the walls of a 3-D chart.
`method`	`getGapDepth()`
`method`	`setGapDepth(value)`
	Gets or sets the distance between the data series in a 3-D chart, as a percentage of the marker width. The value of this property must be between 0 and 500.
`method`	`getGapWidth()`
`method`	`setGapWidth(value)`
	Returns or sets the space between bar or column clusters, as a percentage of the bar or column width. The value of this property must be between 0 and 500.
`method`	`getHeightPercent()`
`method`	`setHeightPercent(value)`
	Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent).
`method`	`getHidePivotFieldButtons()`
`method`	`setHidePivotFieldButtons(value)`
	Indicates whether hide the pivot chart field buttons only when the chart is PivotChart
`method`	`getIs3D()`
	Indicates whether the chart is a 3d chart.
`method`	`isRectangularCornered()`
`method`	`setRectangularCornered(value)`
	Gets or sets a value indicating whether the chart area is rectangular cornered. Default is true.
`method`	`getLegend()`
	Gets the chart legend.
`method`	`getLine()`
	Gets the line.
`method`	`getName()`
`method`	`setName(value)`
	Gets and sets the name of the chart.
`method`	`getNSeries()`
	Gets a SeriesCollection collection representing the data series in the chart.
`method`	`getPageSetup()`
	Represents the page setup description in this chart.
`method`	`getPerspective()`
`method`	`setPerspective(value)`
	Returns or sets the perspective for the 3-D chart view. Must be between 0 and 100. This property is ignored if the RightAngleAxes property is True.
`method`	`getPivotOptions()`
	Specifies the pivot controls that appear on the chart
`method`	`getPivotSource()`
`method`	`setPivotSource(value)`
	The source is the data of the pivotTable. If PivotSource is not empty ,the chart is PivotChart.
`method`	`getPlacement()`
`method`	`setPlacement(value)`
	Represents the way the chart is attached to the cells below it. The value of the property is PlacementType integer constant.
`method`	`getPlotArea()`
	Gets the chart's plot area which includes axis tick labels.
`method`	`getPlotBy()`
	Gets and sets whether plot by row or column. The value of the property is PlotDataByType integer constant.
`method`	`getPlotEmptyCellsType()`
`method`	`setPlotEmptyCellsType(value)`
	Gets and sets how to plot the empty cells. The value of the property is PlotEmptyCellsType integer constant.
`method`	`getPlotVisibleCells()`
`method`	`setPlotVisibleCells(value)`
	Indicates whether only plot visible cells.
`method`	`getPrintSize()`
`method`	`setPrintSize(value)`
	Gets and sets the printed chart size. The value of the property is PrintSizeType integer constant.
`method`	`getRightAngleAxes()`
`method`	`setRightAngleAxes(value)`
	True if the chart axes are at right angles. Applies only for 3-D charts(except Column3D and 3-D Pie Charts).
`method`	`getRotationAngle()`
`method`	`setRotationAngle(value)`
	Represents the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees).
`method`	`getSecondCategoryAxis()`
	Gets the chart's second X axis.
`method`	`getSecondValueAxis()`
	Gets the chart's second Y axis.
`method`	`getSeriesAxis()`
	Gets the chart's series axis.
`method`	`getShapes()`
	Returns all drawing shapes in this chart.
`method`	`getShowDataTable()`
`method`	`setShowDataTable(value)`
	Gets or sets a value indicating whether the chart displays a data table.
`method`	`getShowLegend()`
`method`	`setShowLegend(value)`
	Gets or sets a value indicating whether the chart legend will be displayed. Default is true.
`method`	`getSideWall()`
	Returns a Walls object that represents the side wall of a 3-D chart.
`method`	`getSizeWithWindow()`
`method`	`setSizeWithWindow(value)`
	True if Microsoft Excel resizes the chart to match the size of the chart sheet window.
`method`	`getStyle()`
`method`	`setStyle(value)`
	Gets and sets the builtin style.
`method`	`getSubTitle()`
	Gets the chart's sub-title. Only for ODS format file.
`method`	`getTitle()`
	Gets the chart's title.
`method`	`getType()`
`method`	`setType(value)`
	Gets or sets a chart's type. The value of the property is ChartType integer constant.
`method`	`getValueAxis()`
	Gets the chart's Y axis.
`method`	`getWalls()`
	Returns a Walls object that represents the walls of a 3-D chart.
`method`	`getWallsAndGridlines2D()`
`method`	`setWallsAndGridlines2D(value)`
	True if gridlines are drawn two-dimensionally on a 3-D chart.
`method`	`getWorksheet()`
	Gets the worksheet which contains this chart.

Method Summary
`method`	`calculate()`
`method`	Calculates the custom position of plot area, axes if the position of them are auto assigned.
`method`	`getChartDataRange()`
`method`	Gets the data source range of the chart .
`method`	`hasAxis(aixsType, isPrimary)`
`method`	Returns which axes exist on the chart.
`method`	`isChartDataChanged()`
`method`	Detects if a chart's data source has changed.
`method`	`move(upperLeftRow, upperLeftColumn, lowerRightRow, lowerRightColumn)`
`method`	Moves the chart to a specified location.
`method`	`refreshPivotData()`
`method`	Refreshes pivot chart's data from it's pivot data source.
`method`	`setChartDataRange(area, isVertical)`
`method`	Specifies data range for a chart.
`method`	`switchRowColumn()`
`method`	Switches row/column.
`method`	`toImage(imageFile)`
`method`	Creates the chart image and saves it to a file. The extension of the file name determines the format of the image.
`method`	`toImage(imageFile, imageFormat)`
`method`	Creates the chart image and saves it to a file in the specified format.
`method`	`toImage(imageFile, options)`
`method`	Creates the chart image and saves it to a file. The extension of the file name determines the format of the image.
`method`	`toImage(imageFile, jpegQuality)`
`method`	Creates the chart image and saves it to a file in the Jpeg format.
`method`	`toImageBytes(options)`
`method`	Creates the chart image and saves it to a byte array in the specified format.
`method`	`toPdf(fileName)`
`method`	Saves the chart to a pdf file.
`method`	`toPdf(fileName, desiredPageWidth, desiredPageHeight, hAlignmentType, vAlignmentType)`
`method`	Saves the chart to a pdf file.
`method`	`toPdfBytes()`
`method`	Creates the chart pdf and saves it to a byte array.
`method`	`toPdfBytes(desiredPageWidth, desiredPageHeight, hAlignmentType, vAlignmentType)`
`method`	Creates the chart pdf and saves it to a byte array.

- Property Getters/Setters Detail
  - getStyle/setStyle : int
```
int getStyle() / setStyle(value)
```
    Gets and sets the builtin style.
    It should be between 1 and 48. Return -1 if it's not be set.
  - getChartObject : ChartShape
```
ChartShape getChartObject()
```
    Represents the chartShape;
  - getHidePivotFieldButtons/setHidePivotFieldButtons : boolean
```
boolean getHidePivotFieldButtons() / setHidePivotFieldButtons(value)
```
    Indicates whether hide the pivot chart field buttons only when the chart is PivotChart
  - getPivotOptions : PivotOptions
```
PivotOptions getPivotOptions()
```
    Specifies the pivot controls that appear on the chart
  - getPivotSource/setPivotSource : String
```
String getPivotSource() / setPivotSource(value)
```
    The source is the data of the pivotTable. If PivotSource is not empty ,the chart is PivotChart.
    If the pivot table "PivotTable1" in the Worksheet "Sheet1" in the file "Book1.xls". The pivotSource could be "[Book1.xls]Sheet1!PivotTable1" if the chart and the PivotTable is not in the same workbook. If you set this property ,the previous data source setting will be lost.
  - getPlotBy : int
```
int getPlotBy()
```
    Gets and sets whether plot by row or column. The value of the property is PlotDataByType integer constant.
  - getPlotEmptyCellsType/setPlotEmptyCellsType : int
```
int getPlotEmptyCellsType() / setPlotEmptyCellsType(value)
```
    Gets and sets how to plot the empty cells. The value of the property is PlotEmptyCellsType integer constant.
  - getPlotVisibleCells/setPlotVisibleCells : boolean
```
boolean getPlotVisibleCells() / setPlotVisibleCells(value)
```
    Indicates whether only plot visible cells.
  - getDisplayNaAsBlank/setDisplayNaAsBlank : boolean
```
boolean getDisplayNaAsBlank() / setDisplayNaAsBlank(value)
```
    Indicates whether displaying #N/A as blank value.
  - getName/setName : String
```
String getName() / setName(value)
```
    Gets and sets the name of the chart.
  - getSizeWithWindow/setSizeWithWindow : boolean
```
boolean getSizeWithWindow() / setSizeWithWindow(value)
```
    True if Microsoft Excel resizes the chart to match the size of the chart sheet window.
  - getWorksheet : Worksheet
```
Worksheet getWorksheet()
```
    Gets the worksheet which contains this chart.
  - getShapes : ShapeCollection
```
ShapeCollection getShapes()
```
    Returns all drawing shapes in this chart.
  - getPrintSize/setPrintSize : int
```
int getPrintSize() / setPrintSize(value)
```
    Gets and sets the printed chart size. The value of the property is PrintSizeType integer constant.
  - getType/setType : int
```
int getType() / setType(value)
```
    Gets or sets a chart's type. The value of the property is ChartType integer constant.
  - getNSeries : SeriesCollection
```
SeriesCollection getNSeries()
```
    Gets a SeriesCollection collection representing the data series in the chart.
  - getTitle : Title
```
Title getTitle()
```
    Gets the chart's title.
  - getSubTitle : Title
```
Title getSubTitle()
```
    Gets the chart's sub-title. Only for ODS format file.
  - getPlotArea : PlotArea
```
PlotArea getPlotArea()
```
    Gets the chart's plot area which includes axis tick labels.
  - getChartArea : ChartArea
```
ChartArea getChartArea()
```
    Gets the chart area in the worksheet
  - getCategoryAxis : Axis
```
Axis getCategoryAxis()
```
    Gets the chart's X axis.
  - getValueAxis : Axis
```
Axis getValueAxis()
```
    Gets the chart's Y axis.
  - getSecondValueAxis : Axis
```
Axis getSecondValueAxis()
```
    Gets the chart's second Y axis.
  - getSecondCategoryAxis : Axis
```
Axis getSecondCategoryAxis()
```
    Gets the chart's second X axis.
  - getSeriesAxis : Axis
```
Axis getSeriesAxis()
```
    Gets the chart's series axis.
  - getLegend : Legend
```
Legend getLegend()
```
    Gets the chart legend.
  - getChartDataTable : ChartDataTable
```
ChartDataTable getChartDataTable()
```
    Represents the chart data table.
  - getShowLegend/setShowLegend : boolean
```
boolean getShowLegend() / setShowLegend(value)
```
    Gets or sets a value indicating whether the chart legend will be displayed. Default is true.
  - isRectangularCornered/setRectangularCornered : boolean
```
boolean isRectangularCornered() / setRectangularCornered(value)
```
    Gets or sets a value indicating whether the chart area is rectangular cornered. Default is true.
  - getShowDataTable/setShowDataTable : boolean
```
boolean getShowDataTable() / setShowDataTable(value)
```
    Gets or sets a value indicating whether the chart displays a data table.
  - getFirstSliceAngle/setFirstSliceAngle : int
```
int getFirstSliceAngle() / setFirstSliceAngle(value)
```
    Gets or sets the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical). Applies only to pie, 3-D pie, and doughnut charts, 0 to 360.
  - getGapWidth/setGapWidth : int
```
int getGapWidth() / setGapWidth(value)
```
    Returns or sets the space between bar or column clusters, as a percentage of the bar or column width. The value of this property must be between 0 and 500.
  - getGapDepth/setGapDepth : int
```
int getGapDepth() / setGapDepth(value)
```
    Gets or sets the distance between the data series in a 3-D chart, as a percentage of the marker width. The value of this property must be between 0 and 500.
  - getFloor : Floor
```
Floor getFloor()
```
    Returns a Floor object that represents the walls of a 3-D chart.
    This property doesn't apply to 3-D pie charts.
  - getWalls : Walls
```
Walls getWalls()
```
    Returns a Walls object that represents the walls of a 3-D chart.
    This property doesn't apply to 3-D pie charts.
  - getBackWall : Walls
```
Walls getBackWall()
```
    Returns a Walls object that represents the back wall of a 3-D chart.
  - getSideWall : Walls
```
Walls getSideWall()
```
    Returns a Walls object that represents the side wall of a 3-D chart.
  - getWallsAndGridlines2D/setWallsAndGridlines2D : boolean
```
boolean getWallsAndGridlines2D() / setWallsAndGridlines2D(value)
```
    True if gridlines are drawn two-dimensionally on a 3-D chart.
  - getRotationAngle/setRotationAngle : int
```
int getRotationAngle() / setRotationAngle(value)
```
    Represents the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees).
    The value of this property must be from 0 to 360, except for 3-D bar charts, where the value must be from 0 to 44. The default value is 20. Applies only to 3-D charts.
  - getElevation/setElevation : int
```
int getElevation() / setElevation(value)
```
    Represents the elevation of the 3-D chart view, in degrees.
    The chart elevation is the height at which you view the chart, in degrees. The default is 15 for most chart types. The value of this property must be between -90 and 90, except for 3-D bar charts, where it must be between 0 and 44.
  - getRightAngleAxes/setRightAngleAxes : boolean
```
boolean getRightAngleAxes() / setRightAngleAxes(value)
```
    True if the chart axes are at right angles. Applies only for 3-D charts(except Column3D and 3-D Pie Charts).
    If this property is True, the Perspective property is ignored.
  - getAutoScaling/setAutoScaling : boolean
```
boolean getAutoScaling() / setAutoScaling(value)
```
    True if Microsoft Excel scales a 3-D chart so that it's closer in size to the equivalent 2-D chart. The RightAngleAxes property must be True.
  - getHeightPercent/setHeightPercent : int
```
int getHeightPercent() / setHeightPercent(value)
```
    Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent).
  - getPerspective/setPerspective : int
```
int getPerspective() / setPerspective(value)
```
    Returns or sets the perspective for the 3-D chart view. Must be between 0 and 100. This property is ignored if the RightAngleAxes property is True.
  - getIs3D : boolean
```
boolean getIs3D()
```
    Indicates whether the chart is a 3d chart.
  - getDepthPercent/setDepthPercent : int
```
int getDepthPercent() / setDepthPercent(value)
```
    Represents the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).
  - getActualChartSize : Dimension
```
Dimension getActualChartSize()
```
    Gets actual size of chart
  - getPlacement/setPlacement : int
```
int getPlacement() / setPlacement(value)
```
    Represents the way the chart is attached to the cells below it. The value of the property is PlacementType integer constant.
  - getPageSetup : PageSetup
```
PageSetup getPageSetup()
```
    Represents the page setup description in this chart.
  - getChartShape : ChartShape
```
ChartShape getChartShape()
```
    Represents the chartShape;
    NOTE: This member is now obsolete. Instead, please use Aspose.Cells.Charts.Chart.ChartObject property. This property will be removed 12 months later since JANUARY 2012. Aspose apologizes for any inconvenience you may have experienced.
  - getLine : Line
```
Line getLine()
```
    Gets the line.
- Method Detail
  - toImage
```
 toImage(imageFile)
```
    Creates the chart image and saves it to a file. The extension of the file name determines the format of the image.
    The format of the image is specified by using the extension of the file name. For example, if you specify "myfile.png", then the image will be saved in the PNG format. The following file extensions are recognized: .bmp, .gif, .png, .jpg, .jpeg, .tiff, .tif, .emf.
    If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing. Please refer to Supported Charts List for more details.
    Parameters:
    imageFile: String - The image file name with full path.
  - toImage
```
 toImage(imageFile, imageFormat)
```
    Creates the chart image and saves it to a file in the specified format.
    The format of the image is specified by using imageFormat. The following formats are supported: ImageFormat.Bmp, ImageFormat.Gif, ImageFormat.Png, ImageFormat.Jpeg, ImageFormat.Tiff, ImageFormat.Emf.
    If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing. Please refer to Supported Charts List for more details.
    Parameters:
    imageFile: String - The image file name with full path.
    imageFormat: ImageFormat - The format in which to save the image.
  - toImage
```
 toImage(imageFile, jpegQuality)
```
    Creates the chart image and saves it to a file in the Jpeg format.
    If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing. Please refer to Supported Charts List for more details.
    Parameters:
    imageFile: String - The image file name with full path.
    jpegQuality: long - Jpeg quality.
  - toPdf
```
 toPdf(fileName)
```
    Saves the chart to a pdf file.
    Parameters:
    fileName: String - the pdf file name with full path
  - toPdf
```
 toPdf(fileName, desiredPageWidth, desiredPageHeight, hAlignmentType, vAlignmentType)
```
    Saves the chart to a pdf file.
    Parameters:
    fileName: String - the pdf file name with full path
    desiredPageWidth: float - The desired page width in inches.
    desiredPageHeight: float - The desired page height in inches.
    hAlignmentType: int - A PageLayoutAlignmentType value. The chart horizontal alignment type in the output page.
    vAlignmentType: int - A PageLayoutAlignmentType value. The chart vertical alignment type in the output page.
  - toImage
```
 toImage(imageFile, options)
```
    Creates the chart image and saves it to a file. The extension of the file name determines the format of the image.
    The format of the image is specified by using the extension of the file name. For example, if you specify "myfile.png", then the image will be saved in the PNG format. The following file extensions are recognized: .bmp, .gif, .png, .jpg, .jpeg, .tiff, .tif, .emf.
    If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing. Please refer to Supported Charts List for more details.
    Parameters:
    imageFile: String - The image file name with full path.
    options: ImageOrPrintOptions - Additional image creation options
    Example:
    options = ImageOrPrintOptions() options.setHorizontalResolution(300) options.setVerticalResolution(300) book = Workbook("Book2.xlsx") book.getWorksheets().get(3).getCharts().get(0).toImage("chart.png", options)
  - hasAxis
```
boolean hasAxis(aixsType, isPrimary)
```
    Returns which axes exist on the chart.
    Normally, Pie, PieExploded, PiePie,PieBar, Pie3D, Pie3DExploded,Doughnut, DoughnutExploded is no axis.
    Parameters:
    aixsType - A AxisType value.
  - switchRowColumn
```
boolean switchRowColumn()
```
    Switches row/column.
    Returns:
    False means switching row/column fails.
  - getChartDataRange
```
String getChartDataRange()
```
    Gets the data source range of the chart .
    Only supports range.
    Returns:
    The data source.
  - setChartDataRange
```
 setChartDataRange(area, isVertical)
```
    Specifies data range for a chart.
    Parameters:
    area: String - Specifies values from which to plot the data series
    isVertical: boolean - Specifies whether to plot the series from a range of cell values by row or by column.
  - isChartDataChanged
```
boolean isChartDataChanged()
```
    Detects if a chart's data source has changed.
    The method detects the changes in the chart's data source before rendering the chart to image format. At first Chart.toImage call, the chart source data (e.g. XValuesParseData, ValuesParseData) will be recorded. Before calling the Chart.toImage method again, call IsChartDataChanged method to check if Chart needs re-rendering.
    Returns:
    Returns true if the chart has changed otherwise returns false
  - refreshPivotData
```
 refreshPivotData()
```
    Refreshes pivot chart's data from it's pivot data source.
    We will gather data from pivot data source to the pivot chart cache. This method is only used to gather all data to a pivot chart.
  - move
```
 move(upperLeftRow, upperLeftColumn, lowerRightRow, lowerRightColumn)
```
    Moves the chart to a specified location.
    Parameters:
    upperLeftColumn: int - Upper left column index.
    upperLeftRow: int - Upper left row index.
    lowerRightColumn: int - Lower right column index
    lowerRightRow: int - Lower right row index
  - calculate
```
 calculate()
```
    Calculates the custom position of plot area, axes if the position of them are auto assigned.
  - toImageBytes
```
 toImageBytes(options)
```
    Creates the chart image and saves it to a byte array in the specified format.
    The format of the image is specified by using options.ImageFormat. The following formats are supported: ImageFormat.Bmp, ImageFormat.Gif, ImageFormat.Png, ImageFormat.Jpeg, ImageFormat.Tiff, ImageFormat.Emf.
    If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing. Please refer to Supported Charts List for more details.
    Parameters:
    options: ImageOrPrintOptions - Addtional image creation options
    Returns:
    A byte array.
    Example:
    import jpype import asposecells jpype.startJVM() from asposecells.api import * wb = Workbook("Book2.xlsx") imgOptions = ImageOrPrintOptions() imgOptions.setHorizontalResolution(200) imgOptions.setVerticalResolution(300) imgOptions.setImageFormat(ImageFormat.getJpeg()) chart = wb.getWorksheets().get("Chart").getCharts().get(0) with open("chart.jpeg", "wb") as w: content = chart.toImageBytes(imgOptions) w.write(content) jpype.shutdownJVM()
  - toPdfBytes
```
 toPdfBytes()
```
    Creates the chart pdf and saves it to a byte array.
    Returns:
    A byte array.
    Example:
    import jpype import asposecells jpype.startJVM() from asposecells.api import * wb = Workbook("Book2.xlsx") chart = wb.getWorksheets().get("Chart").getCharts().get(0) with open("chart.pdf", "wb") as w: content = chart.toPdfBytes() w.write(content) jpype.shutdownJVM()
  - toPdfBytes
```
 toPdfBytes(desiredPageWidth, desiredPageHeight, hAlignmentType, vAlignmentType)
```
    Creates the chart pdf and saves it to a byte array.
    Parameters:
    desiredPageWidth: float - The desired page width in inches
    desiredPageHeight: float - The desired page height in inches
    hAlignmentType: int - A PageLayoutAlignmentType value. The chart horizontal alignment type in the output page
    vAlignmentType: int - A PageLayoutAlignmentType value. The chart vertical alignment type in the output page
    Returns:
    A byte array.
    Example:
    import jpype import asposecells jpype.startJVM() from asposecells.api import * wb = Workbook("Book2.xlsx") chart = wb.getWorksheets().get("Chart").getCharts().get(0) with open("chart2.pdf", "wb") as w: content = chart.toPdfBytes(80, 60, PageLayoutAlignmentType.LEFT, PageLayoutAlignmentType.TOP) w.write(content) jpype.shutdownJVM()

asposecells.api

Classes

Constants

Class Chart

Property Getters/Setters Detail

getStyle/setStyle : int

getChartObject : ChartShape

getHidePivotFieldButtons/setHidePivotFieldButtons : boolean

getPivotOptions : PivotOptions

getPivotSource/setPivotSource : String

getPlotBy : int

getPlotEmptyCellsType/setPlotEmptyCellsType : int

getPlotVisibleCells/setPlotVisibleCells : boolean

getDisplayNaAsBlank/setDisplayNaAsBlank : boolean

getName/setName : String

getSizeWithWindow/setSizeWithWindow : boolean

getWorksheet : Worksheet

getShapes : ShapeCollection

getPrintSize/setPrintSize : int

getType/setType : int

getNSeries : SeriesCollection

getTitle : Title

getSubTitle : Title

getPlotArea : PlotArea

getChartArea : ChartArea

getCategoryAxis : Axis

getValueAxis : Axis

getSecondValueAxis : Axis

getSecondCategoryAxis : Axis

getSeriesAxis : Axis

getLegend : Legend

getChartDataTable : ChartDataTable

getShowLegend/setShowLegend : boolean

isRectangularCornered/setRectangularCornered : boolean

getShowDataTable/setShowDataTable : boolean

getFirstSliceAngle/setFirstSliceAngle : int

getGapWidth/setGapWidth : int

getGapDepth/setGapDepth : int

getFloor : Floor

getWalls : Walls

getBackWall : Walls

getSideWall : Walls

getWallsAndGridlines2D/setWallsAndGridlines2D : boolean

getRotationAngle/setRotationAngle : int

getElevation/setElevation : int

getRightAngleAxes/setRightAngleAxes : boolean

getAutoScaling/setAutoScaling : boolean

getHeightPercent/setHeightPercent : int

getPerspective/setPerspective : int

getIs3D : boolean

getDepthPercent/setDepthPercent : int

getActualChartSize : Dimension

getPlacement/setPlacement : int

getPageSetup : PageSetup

getChartShape : ChartShape

getLine : Line

Method Detail

toImage

toImage

toImage

toPdf

toPdf

toImage

hasAxis

switchRowColumn

getChartDataRange

setChartDataRange

isChartDataChanged

refreshPivotData

move

calculate

toImageBytes

toPdfBytes

toPdfBytes