[python-win32] Excel Calculation - Check when it's done

[Bilokon, Paul]

Hi Tim,

Thanks so much!

Is there anything like a "global" Worksheet_Calculate, which would get hit when the entire worksheet calculation is done?

Also, are there many event sync examples in Python?

Many thanks!

Paul

-----Original Message-----
From: python-win32-bounces+paul.bilokon=citi.com at python.org [mailto:python-win32-bounces+paul.bilokon=citi.com at python.org] On Behalf Of Tim Roberts
Sent: 25 August 2009 18:13
To: Python-Win32 List
Subject: Re: [python-win32] Excel Calculation - Check when it's done

Bilokon, Paul wrote:
>
> My apologies as this question is indeed Excel specific though it's
> wide applicability probably merits inclusion here.
>
> Is there any way to determine when a calculation is done in Excel from
> Python over COM, without busy-waiting?
>
> Does anyone have any examples?

Assuming you can register yourself as an event sink, there is a Worksheet_Calculate event that gets fired any time Excel recalculates a
cell.   However, it gets hit an awful lot.

--
Tim Roberts, timr at probo.com
Providenza & Boekelheide, Inc.

_______________________________________________
python-win32 mailing list
python-win32 at python.org
http://mail.python.org/mailman/listinfo/python-win32