//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("A1:C10").setValue(new Object[][]{ {"Task", "Worker 1", "Worker 2"}, {"Task 1", 7, 10}, {"Task 2", 5, 1}, {"Task 3", 3, 6}, {"Task 4", 10, 5}, {"Task 5", 4, 4}, {"Task 6", 5, 8}, {"Task 7", 8, 7}, {"Task 8", 2, 5}, {"Task 9", 6, 4} }); //Create a funnel chart. IShape shape = worksheet.getShapes().addChart(ChartType.Line, 250, 20, 400, 250); shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:C10")); shape.getChart().setHasLegend(false); shape.getChart().getChartTitle().setText(" "); //Add a bussiness logo in the line chart area InputStream stream = this.getResourceStream("logo.png"); try { shape.getChart().addPicture(stream, ImageType.PNG, 170, 10, 60, 10); } catch (IOException e) { e.printStackTrace(); } //Add shapes in the line chart area IShape userShape1 = shape.getChart().addShape(AutoShapeType.Rectangle, 30, 45, 60, 20); userShape1.getFill().getColor().setObjectThemeColor(ThemeColor.Accent2); userShape1.getLine().getColor().setObjectThemeColor(ThemeColor.Accent2); userShape1.getTextFrame().getTextRange().get(0).setText("Worker 2"); IShape userShape2 = shape.getChart().addShape(AutoShapeType.Rectangle, 330, 110, 60, 20); userShape2.getFill().getColor().setObjectThemeColor(ThemeColor.Accent1); userShape2.getLine().getColor().setObjectThemeColor(ThemeColor.Accent1); userShape2.getTextFrame().getTextRange().get(0).setText("Worker 1"); //save to an excel file workbook.save("AddUserShapes.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) worksheet.getRange("A1:C10").setValue(arrayOf(arrayOf("Task", "Worker 1", "Worker 2"), arrayOf("Task 1", 7, 10), arrayOf("Task 2", 5, 1), arrayOf("Task 3", 3, 6), arrayOf("Task 4", 10, 5), arrayOf("Task 5", 4, 4), arrayOf("Task 6", 5, 8), arrayOf("Task 7", 8, 7), arrayOf("Task 8", 2, 5), arrayOf("Task 9", 6, 4))) //Create a funnel chart. val shape = worksheet.shapes.addChart(ChartType.Line, 250.0, 20.0, 400.0, 250.0) shape.chart.seriesCollection.add(worksheet.getRange("A1:C10")) shape.chart.hasLegend = false shape.chart.chartTitle.setText(" ") //Add a bussiness logo in the line chart area val stream = this.getResourceStream("logo.png") try { shape.chart.addPicture(stream, ImageType.PNG, 170.0, 10.0, 60.0, 10.0) } catch (e: IOException) { e.printStackTrace() } //Add shapes in the line chart area val userShape1 = shape.chart.addShape(AutoShapeType.Rectangle, 30.0, 45.0, 60.0, 20.0) userShape1.fill.color.objectThemeColor = ThemeColor.Accent2 userShape1.line.color.objectThemeColor = ThemeColor.Accent2 userShape1.textFrame.textRange.get(0).setText("Worker 2") val userShape2 = shape.chart.addShape(AutoShapeType.Rectangle, 330.0, 110.0, 60.0, 20.0) userShape2.fill.color.objectThemeColor = ThemeColor.Accent1 userShape2.line.color.objectThemeColor = ThemeColor.Accent1 userShape2.textFrame.textRange.get(0).setText("Worker 1") //save to an excel file workbook.save("AddUserShapes.xlsx")