[python-win32] Excel / Word: setting properties

[Niemann, Hartmut]

Hello Tim,

    workbook.CustomDocumentProperties.add(u'Document Confidentiality', False, 4, u'Restricted', False)
    for p in workbook.BuiltinDocumentProperties:
        if p.Name == 'Keywords':
             p.Value = 'C_Restricted'

did the trick for me. Thank you for your support.

Mit freundlichen Grüßen
Dr. Hartmut Niemann

Siemens AG
Mobility Division
Rolling Stock
Standardization, Remote Control, Display
MO RS LM EN CCI SRD
Werner-von-Siemens-Str. 67
91052 Erlangen, Deutschland
Mobil: +49 173 5342327
mailto:hartmut.niemann at siemens.com
www.siemens.com/ingenuityforlife<https://siemens.com/ingenuityforlife>

Von: python-win32 [mailto:python-win32-bounces+hartmut.niemann=siemens.com at python.org] Im Auftrag von Tim Roberts
Gesendet: Freitag, 2. März 2018 09:13
An: Python-Win32 List
Betreff: Re: [python-win32] Excel / Word: setting properties

On Mar 2, 2018, at 12:07 AM, Niemann, Hartmut <hartmut.niemann at siemens.com<mailto:hartmut.niemann at siemens.com>> wrote:

print ('%r' % workbook.BuiltinDocumentProperties)

gives me

<COMObject <unknown>>

What can I do with such an object?

Are you checking the Word object model?  The BuiltinDocumetProperties method returns a DocumentProperties object.  I believe that is a collection of DocumentProperty objects.  So you should be able to say something like

    for prop in workbook.BuiltinDocumentProperties:

—
Tim Roberts, timr at probo.com<mailto:timr at probo.com>
Providenza & Boekelheide, Inc.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-win32/attachments/20180302/d6ea9d38/attachment-0001.html>