How do I get started with PyWin32

python excel python-3.x ms-word pywin32
B-Rell picture B-Rell · May 14, 2013 · Viewed 32.9k times · Source

I am looking for good resources to get started with pywin32. I haven’t found much in the way of tutorials, books or blogs that talk about it. I’d like to be able to use python to automate some of my common repetitive Microsoft Excel and Word Tasks (such as open a word doc and search and replace data from a spreadsheet).

I have found a lot of references to PyWin32 (on google and StackOverflow), but it’s always at a more advanced level. I’d just like to find some well documented resources that help me get up to speed so I can use the other posts I found.

Answer

hellerve picture hellerve · May 14, 2013

What I can recommend if you are okay with buying a book is this guide.

The documentation(can also be found in the installation of PyWin32) and Active State's doc(with their list of objects and modules) should do the rest.

Related questions

append dataframe to excel with pandas

I desire to append dataframe to excel This code works nearly as desire. Though it does not append each time. I run it and it puts data-frame in excel. But each time I run it it does not append. I …

Read More
Pandas: Always selecting the first sheet/tab in an Excel Sheet

I know how to get the list of sheet names. The excel file I am using has multiple sheets. How do I select the first one sequentially ? I don't know the name of the sheet but I need to select …

Read More
How can I see the formulas of an excel spreadsheet in pandas / python?

I would like to read in an excel spreadsheet to python / pandas, but have the formulae instead of the cell results. For example, if cell A1 is 25, and cell B1 is =A1, I would like my dataframe to show: 25 =A1 …

Read More