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

Tim Roberts timr at probo.com
Tue Aug 25 19:13:14 CEST 2009


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.



More information about the python-win32 mailing list