Excel

Discussion in 'Python' started by Alex Martelli, Oct 1, 2003.

  1. ryan scott wrote:

    > Hi,
    >
    > Is it possible to set
    > Application.Calculation = xlCalculationManual
    > in Python?


    Sure, as long as you avoid "from ... import *" (which
    I think is messing you up) AND make sure you've run the
    Python conversion of the Excel type library (it' been
    a while since I last used win32, but as I recall you
    could use EnsureDispatch for the latter purpose).


    Alex
     
    Alex Martelli, Oct 1, 2003
    #1
    1. Advertising

  2. Alex Martelli

    ryan scott Guest

    Hi,

    Is it possible to set
    Application.Calculation = xlCalculationManual
    in Python?

    I tried

    from win32com.client import *

    xlApp = Dispatch("Excel.Application")
    xlApp.Calculation = constants.xlCalculationManual

    but that doesn't work.


    Thanks
    Ryan
     
    ryan scott, Oct 1, 2003
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?SmltIEhlYXZleQ==?=

    Excel _WorkBook vs. Excel.Workbook

    =?Utf-8?B?SmltIEhlYXZleQ==?=, Sep 29, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    3,649
    Steve C. Orr [MVP, MCSD]
    Sep 29, 2004
  2. Luis Esteban Valencia
    Replies:
    1
    Views:
    1,395
    Carl Prothman [MVP]
    Jan 12, 2005
  3. =?Utf-8?B?U3JpZGhhcg==?=

    using Microsoft Excel image for Export to Excel button

    =?Utf-8?B?U3JpZGhhcg==?=, Dec 9, 2005, in forum: ASP .Net
    Replies:
    0
    Views:
    3,116
    =?Utf-8?B?U3JpZGhhcg==?=
    Dec 9, 2005
  4. Anonieko
    Replies:
    2
    Views:
    7,328
    JackStraw73
    Feb 12, 2008
  5. =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=

    Problem with Excel reports ::::Excel 2003 Migration To Excel 2007

    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=, Oct 5, 2007, in forum: ASP .Net
    Replies:
    15
    Views:
    1,526
    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=
    Oct 24, 2007
Loading...

Share This Page