Session Details

Programming Microsoft Office using Python  

Level :
Intermediate
Date :
3:30 PM Sunday
Room :
5501
Interested : (-) - Registered : (-)

Presentation

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>

The Speaker(s)

img

wesley chun

+WESLEY CHUN, MSCS, is the author of Prentice Hall's bestselling "Core Python" book series & companion videos (corepython.com), co-author of "Python Web Development with Django" (withdjango.com), and has written for Linux Journal, CNET, and InformIT. In addition to being an engineer & Developer Advocate at Google, he runs CyberWeb (cyberwebconsulting.com), a consultancy specializing in Python training. Wesley has over 25 years of programming, teaching, and writing experience, including helping create Yahoo!Mail using Python almost 2 decades ago. He has taught numerous Python courses at Cisco, Disney, VMware, UC Santa Barbara, UC Santa Cruz, & Foothill College. Wesley holds degrees in CS, Math, and Music from the University of California, and loves traveling worldwide to meet developers, whether at a technical conference, user group meeting, or on a university campus. He is a Fellow of the Python Software Foundation and can be reached on Google+ or Twitter (@wescpy).
  • Not Interested
  • Interested
  • Attending

SPONSORS List