//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); IShape shape = worksheet.getShapes().addChart(ChartType.LineMarkers, 250, 20, 360, 230); worksheet.getRange("A1:B6").setValue(new Object[][]{ {null, "S1"}, {"Item1", 10}, {"Item2", -51}, {"Item3", 52}, {"Item4", 22}, {"Item5", 40} }); shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:D6"), RowCol.Columns, true, true); ISeries series1 = shape.getChart().getSeriesCollection().get(0); //config line markers style series1.getMarkerFormat().getFill().getColor().setRGB(Color.GetCornflowerBlue()); series1.getMarkerFormat().getLine().setStyle(LineStyle.ThickThin); series1.getMarkerFormat().getLine().getColor().setRGB(Color.GetLightGreen()); series1.getMarkerFormat().getLine().setWeight(3); //save to an excel file workbook.save("ConfigMarkersFormat.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val shape = worksheet.shapes.addChart(ChartType.LineMarkers, 250.0, 20.0, 360.0, 230.0) worksheet.getRange("A1:B6").value = arrayOf(arrayOf(null, "S1"), arrayOf("Item1", 10), arrayOf("Item2", -51), arrayOf("Item3", 52), arrayOf("Item4", 22), arrayOf("Item5", 40)) shape.chart.seriesCollection.add(worksheet.getRange("A1:D6"), RowCol.Columns, true, true) val series1 = shape.chart.seriesCollection.get(0) //config line markers style series1.markerFormat.fill.color.rgb = Color.GetCornflowerBlue() series1.markerFormat.line.style = LineStyle.ThickThin series1.markerFormat.line.color.rgb = Color.GetLightGreen() series1.markerFormat.line.weight = 3.0 //save to an excel file workbook.save("ConfigMarkersFormat.xlsx")