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()); |