// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); IShape shape = worksheet.getShapes().addShape(AutoShapeType.Parallelogram, 1, 1, 200, 100); shape.setWidth(500); shape.setHeight(200); shape.getTextFrame().getTextRange().getFont().getColor().setRGB(Color.FromArgb(0, 255, 0)); shape.getTextFrame().getTextRange().getFont().setBold(true); shape.getTextFrame().getTextRange().getFont().setItalic(true); shape.getTextFrame().getTextRange().getFont().setSize(20); shape.getTextFrame().getTextRange().getFont().setStrikethrough(true); shape.getTextFrame().getTextRange().getParagraphs().add("This is a parallelogram shape."); shape.getTextFrame().getTextRange().getParagraphs().add("My name is XXX"); shape.getTextFrame().getTextRange().getParagraphs().get(1).getRuns().add("Hello World!"); shape.getTextFrame().getTextRange().getParagraphs().get(1).getRuns().get(0).getFont().setStrikethrough(false); shape.getTextFrame().getTextRange().getParagraphs().get(1).getRuns().get(0).getFont().setSize(35); // Save to an excel file workbook.save("SetShapeText.xlsx");
// Create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val shape = worksheet.shapes.addShape(AutoShapeType.Parallelogram, 1.0, 1.0, 200.0, 100.0) shape.width = 500.0 shape.height = 200.0 shape.textFrame.textRange.font.color.rgb = Color.FromArgb(0, 255, 0) shape.textFrame.textRange.font.bold = true shape.textFrame.textRange.font.italic = true shape.textFrame.textRange.font.size = 20.0 shape.textFrame.textRange.font.strikethrough = true shape.textFrame.textRange.paragraphs.add("This is a parallelogram shape.") shape.textFrame.textRange.paragraphs.add("My name is XXX") shape.textFrame.textRange.paragraphs.get(1).runs.add("Hello World!") shape.textFrame.textRange.paragraphs.get(1).runs.get(0).font.strikethrough = false shape.textFrame.textRange.paragraphs.get(1).runs.get(0).font.size = 35.0 // Save to an excel file workbook.save("SetShapeText.xlsx")