Does anyone have an example of reading an Excel spreadsheet and iteratively copying the VALUES from each of the cells in each of the sheets over to a new spreadsheet?
TIA
alagalah
Last Activity: Feb 24 '09, 07:24 PM
Joined: Feb 17 '09
Location:
-
Copying values from one spreadsheet to another
-
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! -
Wait for Excel to calculate
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.
No activity results to display
Leave a comment: