Re: [python-win32] Opening, Modifying, and Saving an Excel File from Python?

2011-08-23 Thread Little Guy
Mr. Roberts, I tried your suggestion about the varialble.quit() usage but still get the same results. What normally happens is that I open up the excel file, and make it visible. I then try to populate two cells, at the last row + 1 with text, then try to save, close and quit. What occurs

Re: [python-win32] Opening, Modifying, and Saving an Excel File from Python?

2011-08-23 Thread David Robinow
On Sat, Aug 20, 2011 at 10:55 PM, The Little Guy the_little_...@gmx.com wrote: Hi, I apologize for the lengthy post. The code you posted does not run at all. I had to rename a few things to get it to do anything at all. It appears that xlrd is holding a reference to the excel file. I was able

Re: [python-win32] Opening, Modifying, and Saving an Excel File from Python? (Tim Roberts)

2011-08-23 Thread The Little Guy
Mr. Roberts, I've actually, gone through the, routine of placing quit in multiple places but still I get errors. Either an unknown process error is generated or another instance of Excel pops up, with a SaveAs dialog, box, with a random filename as default. Something has grabbed the excel

Re: [python-win32] Opening, Modifying, and Saving an Excel File from Python? (Tim Roberts)

2011-08-23 Thread Tim Roberts
The Little Guy wrote: Mr. Roberts, I’ve actually, gone through the, routine of placing quit in multiple places but still I get errors. Either an unknown process error is generated or another instance of Excel pops up, with a SaveAs dialog, box, with a random filename as default.

Re: [python-win32] Opening, Modifying, and Saving an Excel File from Python?

2011-08-23 Thread The Little Guy
Mr. Robinow, The code is only a small test code, not really meant to do anything. It's just meant to be used as a simple test to see if I can save data onto an excel sheet. This is the final part of larger code project. All it does is open an excel file, append data to it, and try to

Re: [python-win32] Opening, Modifying, and Saving an Excel File from Python? (Tim Roberts) [SEC=PERSONAL]

2011-08-23 Thread Andrew MacIntyre
The code you posted doesn't look right, but I suspect your code is not properly cleaning up all references to Excel objects before terminating, and you will find you still have an Excel process in the background which is hanging on to the file (hence the sharing violations). I have encountered