[python-win32] Excel + pyinstaller: missing a constant: xlTopToBottom

[Niemann, Hartmut]

Hello!

The following snippet

    from win32com.client import constants as xl_constants
    wbook.ActiveSheet.Range('A3:N' + str(row + 1)).Sort(
        Key1 = wbook.ActiveSheet.Range('B3'),
        Orientation = xl_constants.xlTopToBottom,
        DataOption1 = xl_constants.xlSortTextAsNumbers
    )
from a script that is exe-fied with pyinstaller fails with

Traceback (most recent call last):
  File "<string>", line 502, in process_chain
  File "<string>", line 451, in process_project
  File "<string>", line 330, in create_fg
  File "D:\temp\lib_chain\out00-PYZ.pyz\win32com.client", line 170, in __getattr__
AttributeError: xlTopToBottom

Is this a pywin problem? Do we need to instruct pyinstaller to work differently to cooperate with Excel?
Any ideas?

(This is python 2.7.3 on Windows XP)



Mit freundlichen Grüßen
Dr. Hartmut Niemann

Siemens AG
Infrastructure & Cities Sector
Rail Systems Division
Locomotives and Components
IC RL LOC EN LE 8
Werner-von-Siemens-Str. 67
91052 Erlangen, Deutschland
Tel.: +49 9131 7-34264
Fax: +49 9131 7-26254
mailto:hartmut.niemann at siemens.com

Siemens Aktiengesellschaft: Vorsitzender des Aufsichtsrats: Gerhard Cromme; Vorstand: Peter Löscher, Vorsitzender; Roland Busch, Brigitte Ederer, Klaus Helmrich, Joe Kaeser, Barbara Kux, Hermann Requardt, Siegfried Russwurm, Peter Y. Solmssen, Michael Süß; Sitz der Gesellschaft: Berlin und München, Deutschland; Registergericht: Berlin Charlottenburg, HRB 12300, München, HRB 6684; WEEE-Reg.-Nr. DE 23691322

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-win32/attachments/20130429/6d3de49c/attachment.html>