Shape

Add Shape

def add_shape(sheet: str, opts: Shape) -> None

Add shape in a sheet by given worksheet index, shape format set (such as offset, scale, aspect ratio setting and print settings) and properties set. For example, add text box (rect shape) in Sheet1:

import excelize

f = excelize.new_file()
try:
    f.add_shape(
        "Sheet1",
        excelize.Shape(
            cell="G6",
            type="rect",
            line=excelize.ShapeLine(
                color="4286F4",
                width=1.2,
            ),
            fill=excelize.Fill(
                color=["8EB9FF"],
                pattern=1,
            ),
            paragraph=[
                excelize.RichTextRun(
                    text="Rectangle Shape",
                    font=excelize.Font(
                        bold=True,
                        italic=True,
                        family="Times New Roman",
                        size=19,
                        color="777777",
                        underline="sng",
                    ),
                )
            ],
            width=80,
            height=40,
        ),
    )
    f.save_as("Book1.xlsx")
except (RuntimeError, TypeError) as err:
    print(err)
finally:
    err = f.close()
    if err:
        print(err)

The following shows the type of shape supported by excelize: