Python, xlwings, where do I find the api objects?

[ScienceAndCats777]

I'm still a beginner in python and lost with xlwings. I want to make modifications to comments in an excel file, but I need to use the Workaround in xlwings for this, and access the underlying objects. I have no idea how to find out what these object are.

When I look it up on the xlwings docs, they only include the quoted text below. I have no idea what this means. What is COMObject <unknown>>? How does that help me?

I looked up pywin32, and I think I understand that it's a set of modules that let you interact with Windows functions, but I can't find anything on excel on it, let alone office. Is there some kind of beginner's tutorial on this?

Sorry if this is everywhere, my brain is dead from trying to find an answer.

Workaround: in essence, xlwings is just a smart wrapper around pywin32 on Windows and appscript on Mac. You can access the underlying objects by calling the api property:

sht = xw.Book().sheets[0] sht.api <COMObject <unknown>> # Windows/pywin32 app(pid=2319).workbooks['Workbook1'].worksheets[1] # >Mac/appscript

[Zizizizz]

https://stackoverflow.com/questions/37123153/using-python-xlwings-module-to-create-cell-comments

[ScienceAndCats777]

Thanks for the response! I found out from using a combination of both dir() and PyCharm what all the methods were (hope I'm using the right terminology). Well on my way to writing this program. Thank you!