openpyxl textbox support in 3.1.2

[Bhavin Bhatt]

Hello all,

Am new to this community. I have a task to save an existing *.xlsx file with textbox already in it.

Issue: When I open an existing abc.xlsx (attached here) file, and save it with same or different name, the textbox that has a text = "Sample TEXT" is removed after save. 

===Code===

import openpyxl

work_book = openpyxl.load_workbook("abc.xlsx")
work_book.save("abc.xlsx")

===

I think this seems to be a known issue, so I thought of adding textbox manually, but I cannot find a single example so far that demos it. I have been trying all the properties provided in documentation (https://openpyxl.readthedocs.io/en/3.1.2/) but none of them work.

If anyone knows which version it is fully supported please let me know.

Any help would be appreciated.

Thank you in advance.

[pw wang]

Hi, Bhatt,

I encounter same problem, and google leads me to you. looks like no solution so far?