[]
        
(Showing Draft Content)

IWall

Interface IWall


public interface IWall
Represents the walls of a 3-D chart.

A wall is the plane behind or beside a 3-D chart. Use this interface to access the wall's IChartFormat and to control its thickness for walls returned by IChart.getBackWall() or IChart.getSideWall().


 worksheet.getRange("A1:B3").setValue(new Object[][] {
     {"Name", "Value"},
     {"A", 1},
     {"B", 2}
 });
 IShape shape = worksheet.getShapes().addChart(ChartType.Column3D, 10, 10, 250, 250);
 shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:B3"), RowCol.Columns, true, true);
 IWall wall = shape.getChart().getSideWall();
 wall.setThickness(20);
 wall.getFormat().getFill().getColor().setRGB(Color.GetRed());
 
  • Method Summary

    Modifier and Type
    Method
    Description
    Gets the chart format of the wall.
    Gets the parent chart that contains this wall.
    int
    Gets the thickness of the wall.
    void
    setThickness(int value)
    Sets the thickness of the wall.
  • Method Details

    • getParent

      IChart getParent()
      Gets the parent chart that contains this wall.

      The returned IChart is the 3-D chart that owns this wall, such as the back wall or side wall.

      
       IChart chart = worksheet.getShapes().addChart(ChartType.ColumnClustered3D, 20, 20, 360, 220).getChart();
       IChart parentChart = chart.getBackWall().getParent();
       
      Returns:
      The parent IChart that contains this wall.
    • getFormat

      IChartFormat getFormat()
      Gets the chart format of the wall.

      The returned IChartFormat object provides access to the wall's fill and line formatting for a 3-D chart.

      
       IChart chart = worksheet.getShapes().addChart(ChartType.ColumnClustered3D, 20, 20, 360, 220).getChart();
       IChartFormat format = chart.getBackWall().getFormat();
       format.getFill().getColor().setRGB(Color.GetRed());
       
      Returns:
      The IChartFormat object that represents the wall formatting.
    • getThickness

      int getThickness()
      Gets the thickness of the wall.

      Use this method to read the current thickness setting of a wall in a 3-D chart, such as the back wall or side wall.

      
       IChart chart = worksheet.getShapes().addChart(ChartType.ColumnClustered3D, 20, 20, 360, 220).getChart();
       chart.getBackWall().setThickness(5);
       int thickness = chart.getBackWall().getThickness();
       
      Returns:
      The thickness of the wall.
    • setThickness

      void setThickness(int value)
      Sets the thickness of the wall.

      Use this method to set the thickness of a wall in a 3-D chart, such as the back wall or side wall.

      
       IChart chart = worksheet.getShapes().addChart(ChartType.ColumnClustered3D, 20, 20, 360, 220).getChart();
       chart.getBackWall().setThickness(5);
       
      Parameters:
      value - The thickness of the wall.