Re: [Py2exe-users] win32com and Excel

[Alok N. <tux...@gm...>]

Hi Stefanie,

If your question is about what you need to do to create a Python executable that
will inter-operate with MS-Office 2003 and MS-Office 2007, I can suggest the
following solution which worked for me.

Add the typelibs for MS-Office 2003 as well as MS-Office 2007 into your typelibs
argument as shown in my setup.py below:

#!/usr/bin/env python

from distutils.core import setup
import enchant.utils
import py2exe

py2exe_options = dict(
                      excludes=['_ssl', "Tkconstants", "Tkinter", "tcl",
                                'pyreadline', 'difflib', 'doctest',
                                'pickle', 'calendar', 'pygments', 'email'],
                      dll_excludes=['msvcr71.dll'],  # Exclude msvcr71
                      typelibs = [('{00020813-0000-0000-C000-000000000046}',0,1,5),
                        ('{00020813-0000-0000-C000-000000000046}',0,1,6)],
                      )

docsentry_files = [("dswin_wdr",['dswin_wdr/DSBitmapsFunc_0.png',
                                 'dswin_wdr/DSBitmapsFunc_1.png',
                                 'dswin_wdr/DSBitmapsFunc_2.png',
                                 'dswin_wdr/DSBitmapsFunc_3.png',
                                 'dswin_wdr/DSBitmapsFunc_4.png',
                                 'dswin_wdr/DSBitmapsFunc_5.png',
                                 'dswin_wdr/DSBitmapsFunc_6.png',
                                 'dswin_wdr/DSBitmapsFunc_7.png',
                                 'dswin_wdr/DSBitmapsFunc_8.png',
                                 'dswin_wdr/DSBitmapsFunc_9.png',              
               
                                 'dswin_wdr/DSBusy.png',                       
      
                                 'dswin_wdr/DSDone.png',                       
      
                                 'dswin_wdr/DSIdle.png',                       
      
                                 ])]
docsentry_files.extend(enchant.utils.win32_data_files())

setup(
    name="DocSentry",
    version="2.0",
    author="Alok Narula",
    description="HTIPL HMS Compliance Checker",
    options={'py2exe': py2exe_options},
    data_files = docsentry_files,
    platforms="win32",
    windows=[{"script" : "dswin.pyw",
         "icon_resources": [(3, 'dswin_wdr/DocSentry.ico')]}], 
    console=['docsentry.py']
)

Best regards,
Alok