For automation purposes, I am trying to create rectangle shapes that I will fill with data coming from a sheet.

I am trying to create rectangle objects directly into an Excel sheet.

My objective is to automate a repetitive process. Those rectangles will later be filled with data coming from an external source.

I’d like to write a Python code that reads an Excel sheet, let’s name it “Sheet1”, and for each value in “Measure” column, creates a pair of rectangles in a new sheet.
Here’s an example of the format in Sheet1:

And the expected output should look like :

I tried reaching my goal using “insert_shape” or openpyxl drawing library, without success as it seems not to be available anymore.
Could you kindly help me ?