//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); IShape shape = worksheet.getShapes().addChart(ChartType.ColumnClustered, 250, 20, 360, 230); 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); IAxis value_axis = shape.getChart().getAxes().item(AxisType.Value); value_axis.setHasMajorGridlines(true); value_axis.setHasMinorGridlines(true); value_axis.getMajorGridlines().getFormat().getLine().getColor().setRGB(Color.GetGray()); value_axis.getMajorGridlines().getFormat().getLine().setWeight(1); value_axis.getMinorGridlines().getFormat().getLine().getColor().setRGB(Color.GetLightGray()); value_axis.getMinorGridlines().getFormat().getLine().setWeight(0.75); value_axis.setMajorUnit(40); value_axis.setMinorUnit(8); value_axis.getMinorGridlines().getFormat().getLine().setStyle(LineStyle.ThickThin); //save to an excel file workbook.save("ConfigGridlines.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val shape = worksheet.shapes.addChart(ChartType.ColumnClustered, 250.0, 20.0, 360.0, 230.0) worksheet.getRange("A1:D6").value = arrayOf(arrayOf(null, "S1", "S2", "S3"), arrayOf("Item1", 10, 25, 25), arrayOf("Item2", -51, -36, 27), arrayOf("Item3", 52, -85, -30), arrayOf("Item4", 22, 65, 65), arrayOf("Item5", 23, 69, 69)) shape.chart.seriesCollection.add(worksheet.getRange("A1:D6"), RowCol.Columns, true, true) val value_axis = shape.chart.axes.item(AxisType.Value) value_axis.hasMajorGridlines = true value_axis.hasMinorGridlines = true value_axis.majorGridlines.format.line.color.rgb = Color.GetGray() value_axis.majorGridlines.format.line.weight = 1.0 value_axis.minorGridlines.format.line.color.rgb = Color.GetLightGray() value_axis.minorGridlines.format.line.weight = 0.75 value_axis.majorUnit = 40.0 value_axis.minorUnit = 8.0 value_axis.minorGridlines.format.line.style = LineStyle.ThickThin //save to an excel file workbook.save("ConfigGridlines.xlsx")