Floor | Document Solutions for Excel, Java Edition

Floor

In This Topic

In DsExcel Java, floor represents the floor of a three-dimensional chart. Using floor as the charting object, you can format the area of a 3-D chart quickly and efficiently.

Users can set the line and fill format of the floor along with its thickness.

To set the floor format in a chart, refer to the following example code.

Java	Copy Code
IShape shape = worksheet.getShapes().addChart(ChartType.Column3D, 250, 20, 350, 250); worksheet.getRange("A1:D6").setValue( new Object[][] { { null, "S1", "S2", "S3" }, { "Item1", 10, 25, 25 }, { "Item2", -51, -36, 27 }, { "Item3", 52, -85, -30 }, { "Item4", 22, 65, 65 }, { "Item5", 23, 69, 69 } }); shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:D6"), RowCol.Columns, true, true); shape.getChart().getFloor().setThickness(5); shape.getChart().getFloor().getFormat().getFill().getColor().setRGB(Color.GetYellow()); shape.getChart().getFloor().getFormat().getLine().getColor().setRGB(Color.GetRed());

Java

Copy Code

IShape shape = worksheet.getShapes().addChart(ChartType.Column3D, 250, 20, 350, 250);
worksheet.getRange("A1:D6").setValue(
        new Object[][] { { null, "S1", "S2", "S3" }, { "Item1", 10, 25, 25 }, { "Item2", -51, -36, 27 },
                { "Item3", 52, -85, -30 }, { "Item4", 22, 65, 65 }, { "Item5", 23, 69, 69 } });
shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:D6"), RowCol.Columns, true, true);

shape.getChart().getFloor().setThickness(5);
shape.getChart().getFloor().getFormat().getFill().getColor().setRGB(Color.GetYellow());
shape.getChart().getFloor().getFormat().getLine().getColor().setRGB(Color.GetRed());