By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,898 Members | 1,183 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,898 IT Pros & Developers. It's quick & easy.

Wait for Excel to calculate

P: 3
Hi there,

I have a series of Excel sheets with some heavy calculations (may take about a minute for them to calc).

I want Python to open the spreadsheets and wait until the calc stops before retrieving values.

I have attempted using sleep(60) but would like something a little more "deterministic". Is there anyway to get a status on when calculations are done?

TIA.
Feb 17 '09 #1
Share this Question
Share on Google+
2 Replies


P: 3
Actually my problem wasn't with calculation as it does this automatically.

I thought I was access a cell before it had calculated, hence I got bad data.

Turns out I had to launch the Add-In required to calculate the cell as using COM, that doesn't happen!
Feb 21 '09 #2

bvdet
Expert Mod 2.5K+
P: 2,851
Thanks for sharing the solution with us alagalah. :)

-BV
Feb 22 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.