vendredi 22 décembre 2017

Python: Add checkbox in Excel cell using PyWin32 and VBA code

I am trying to add a checkbox in certain cells in an excel sheet. I am opening an existing sheet using win32com

I can't really find any solutions when googling, the closest i have come is this question:

python: how to insert checkbox in excel?

Where he apparently found a solution himself using VBA code, but didn't post the solution. I have tried similar stuff by doing:

Sheet.CheckBoxes.Add()

But i get an error saying that function CheckBoxes has no attribute "Add". Ideally i want to do something like this:

Sheet.CheckBoxes.Add(row, col)

How can i go about doing that?




Aucun commentaire:

Enregistrer un commentaire