3:30 PM Sunday
Silicon Valley Code Camp : October 3rd and 4th, 2009session

Programming Microsoft Office using Python


About This Session

Like it or not, we live in a world where we will interact with Win32 systems. It may be intermittent or something we have to deal with it on a daily basis, but regardless of how much exposure we face, the power of Python can be used to make our lives easier. In this session, we will explore Win32 COM Client programming using Python to control and communicate with Office applications such as Word, Excel, PowerPoint, and Outlook. COM is a service which allows Win32 applications to interact with each other. (Specifically, well-known applications such as those in Microsoft Office provide COM services, and COM client programs can be written to drive these applications.) </p><p></p><br> <br/> Traditionally, COM clients are written in VB or (Visual) C++, two very powerful but very different tools. If you haven't already heard, Python is a systems application development language that is gaining popularity in a huge way. It is object-oriented, robust, agile, and easy-to-learn. It's as simple as VB but can do everything that C/C++, Java, Perl, PHP, and Ruby can do... and more. For COM programming, Python is often viewed as a great substitute as it is more powerful than VB and is more expressive and less time-consuming than developing in C++. </p><p></p><br> <br/> This lecture is designed for both COM developers who want to learn how they can apply Python in their world and also for Python programmers who need to learn how to create COM clients, i.e., auto-generate Excel spreadsheets, create form letters as Word documents, make slide presentations automagically with PowerPoint, send e-mail via Outlook, etc. (We will not be discussing the principles/concepts of COM nor will we be learning about COM+, VSTO, ATL, IDL, MFC, DCOM, ADO, .NET, IronPython, etc.) </p><p></p><br> <br/> Instead, we will immerse you in COM client programming by learning how to use Python to communicate with some of the Office applications mentioned above. All of the examples used in lecture can be found in Prentice Hall's bestseller, "Core Python Programming" (2nd ed). We delivered this talk at PyCon 2008, and Silicon Valley CodeCamps over the past 3 years: </p><p></p><br> </p><br>http://cc07.siliconvalley-codecamp.com/Sessions.aspx?OnlyOne=true&id=141 </p><br><br/>http://cc06.siliconvalley-codecamp.com/Sessions.aspx?OnlyOne=true&id=30 </p><br><br/>http://us.pycon.org/2008/conference/talks/?search=microsoft+office </p><p></p><br> <br/> If you are new to Python, be sure to also attend our "What is Python?" talk, also being given at CodeCamp this year again. </p>

Time: 3:30 PM Sunday    Room: 5501 

The Speaker(s)

undefined undefined

Wesley Chun

developer advocate , CyberWeb & Google

WESLEY CHUN is author of the "Core Python" books and an engineer & Developer Advocate at Google.