Programming Microsoft Office
using Python

TBD
TBD, CA

Like it or not, we live in a world where we will eventually have to interact with Win32 systems (if not already). 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. Win32 COM is a service which allows applications to interact with each other. Specifically, Microsoft Office applications provide COM services, and COM client programs can be written to drive them. Traditionally, such clients are written in VB or (Visual) C++, two very powerful but very different tools.

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 is as simple as VB but can do everything that C/C++, Java, Perl, PHP, and Ruby can do. 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++.

The seminar exposes attendees to programming Win32 COM clients using Python. It 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. This is not a course in the fundamentals of COM: we will not be discussing the principles, concepts, and fundamentals of COM, philosophize on thoughts such as "Why COM?", nor we will not be learning about COM+, ATL, IDL, MFC, DCOM, ADO, etc.

Instead, we will immerse you in COM client programming by learning how to use Python to communicate with a variety of Microsoft applications, specifically Excel, Word, PowerPoint, and Outlook. We will have practical hands-on lab exercises where you will write small snippets of code that talk to and drive those applications. Time-permitting, we will also explore programming OpenOffice2, specifically running it in "server mode", and how to use (Star) writer to convert documents, e.g., Word to PDF.

Students completing this course should have a solid understanding of what COM client programming with Python is all about as well as being able to create simple scripts to drive the most well-known Microsoft Office applications. Specific topics include:

  • Introduction to Win32 COM
  • COM servers and clients
  • How to write COM clients in Python
  • Programming Microsoft Word
  • Programming Microsoft Excel
  • Programming Microsoft PowerPoint
  • Programming Microsoft Outlook
  • (time-permitting) OpenOffice Programming

PREREQUISITE: Attendees should be technical professionals somewhat familiar with Python. COM programming experience and a basic understanding of the Win32 architecture are not necessary but may be helpful. We especially welcome those coming from Unix-oriented environments (Linux, MacOS X, Solaris, *BSD, etc.) who are not familiar with Win32 programming but want to add it to their toolbox or need to learn it for their profession.

REQUIRED SOFTWARE: A Python interpreter is required for this course as well as the Python for Windows Extensions. Both of thse can be downloaded at the Core Python Programming website. You must also have a 32-bit Microsoft operating system as well as Microsoft Office applications: Word, Excel, PowerPoint, and Outlook.

REQUIRED HARDWARE: A laptop/notebook or otherwise portable computer is required for the course exercises. Attendees may use any Win32 platform where the above software is available. Bring your power cord!

INSTRUCTOR: WESLEY J. CHUN, MSCS, is the author of Prentice Hall's bestseller, "Core Python Programming", its video training course, "Python Fundamentals" (LiveLessons DVD), co-author of Python Web Development with Django", and has also written various technical articles for Linux Journal and cNet. He is currently a senior engineer at NearbyNow and also runs CyberWeb, a consulting business specializing in Python software engineering and technical training. He has over 25 years of programming, teaching, and writing experience, including more than a decade of Python. While at Yahoo!, he helped create Yahoo! Mail and Yahoo! People Search using Python. He holds degrees in Computer Science, Mathematics, and Music from the University of California.

COURSE FEE: $495US per person. Enrollment limited.

Home

Python Training

Other Services

Our Staff

Contact Us

Notify me by e-mail:

Training Events
Core Python 2e
PrivacyPolicy

last updated:
$Date: 2008/09/11 07:43:00 $