//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.getFill().presetTextured(PresetTexture.Canvas); shape.getFill().setTextureAlignment(TextureAlignment.Center); shape.getFill().setTextureOffsetX(2.5); shape.getFill().setTextureOffsetY(3.2); shape.getFill().setTextureHorizontalScale(0.9); shape.getFill().setTextureVerticalScale(0.2); shape.getFill().setTransparency(0.5); //save to an excel file workbook.save("ConfigShapeWithTextureFill.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.fill.presetTextured(PresetTexture.Canvas) shape.fill.textureAlignment = TextureAlignment.Center shape.fill.textureOffsetX = 2.5 shape.fill.textureOffsetY = 3.2 shape.fill.textureHorizontalScale = 0.9 shape.fill.textureVerticalScale = 0.2 shape.fill.transparency = 0.5 //save to an excel file workbook.save("ConfigShapeWithTextureFill.xlsx")