Re: [python-win32] Pythonwin starts, displays main window, interactive window 'frame', then exits

2008-12-12 Thread Alec Bennett
Run it from commandline and see if an error message is printed the console? --- On Thu, 12/11/08, John_Nowlan john_now...@carleton.ca wrote: From: John_Nowlan john_now...@carleton.ca Subject: [python-win32] Pythonwin starts, displays main window, interactive window 'frame', then exits

[python-win32] Writing to Excel performance

2008-12-12 Thread Dominick Lauzon
Hi, I have large matrices of data to push to excel and I find the writing of data to excel to be excessively slow (cell by cell method) even if the Visible is to False. Right now I reverted back to a 2 step CSV - Import to Excel but it is far from ideal. Is there any trick to

Re: [python-win32] Writing to Excel performance

2008-12-12 Thread Dahlstrom, Roger
Couple of tricks I've used with some success... 1. If this is data only, and not formulas, you can write the data as an html table, but name the file something.xls - Excel will open it natively. 2. If you need special formatting or formulas, you can write the data as Excel's HTML templates

Re: [python-win32] Writing to Excel performance

2008-12-12 Thread Tim Golden
Dominick Lauzon wrote: I have large matrices of data to push to excel and I find the writing of data to excel to be excessively slow (cell by cell method) even if the Visible is to False. Right now I reverted back to a 2 step CSV - Import to Excel but it is far from ideal. Is there any

Re: [python-win32] Simulating a mouse click - lParam

2008-12-12 Thread Rickey, Kyle W
Ok, I did some more googling and found a solution to this problem. http://www.codeguru.com/forum/showthread.php?t=229822 Suggest using TCM_SETCURFOCUS instead of TCM_SETCURSEL. So here's the code that works to change to a given tab. TCM_SETCURFOCUS = 0x1330 win32gui.SendMessage(hwnd,

Re: [python-win32] Writing to Excel performance

2008-12-12 Thread Tim Roberts
Dahlstrom, Roger wrote: Couple of tricks I've used with some success... 1. If this is data only, and not formulas, you can write the data as an html table, but name the file something.xls - Excel will open it natively. 2. If you need special formatting or formulas, you can write the data

Re: [python-win32] Writing to Excel performance

2008-12-12 Thread Dahlstrom, Roger
I understand where you're coming from, I just don't like how Windows handles such things. My opinion is that determining file type by extension (arbitrary at that) is a bad thing to begin with. -Original Message- From: python-win32-bounces+rdahlstrom=directedge@python.org

Re: [python-win32] Writing to Excel performance

2008-12-12 Thread Tim Roberts
Dahlstrom, Roger wrote: I understand where you're coming from, I just don't like how Windows handles such things. My opinion is that determining file type by extension (arbitrary at that) is a bad thing to begin with. This is veering a bit off-topic for this mailing list, but I'd be

[python-win32] comtypes 0.5.3 released

2008-12-12 Thread Thomas Heller
I just released comtypes-0.5.3. comtypes is a lightweight Python COM package, based on the ctypes FFI library, in less than 1 lines of code (not counting the tests). comtypes allows to define, call, and implement custom and dispatch-based COM interfaces in pure Python.

Re: [python-win32] Writing to Excel performance

2008-12-12 Thread Greg Ewing
Tim Roberts wrote: Dahlstrom, Roger wrote: My opinion is that determining file type by extension (arbitrary at that) is a bad thing to begin with. This is veering a bit off-topic for this mailing list, but I'd be curious to hear what alternatives you would suggest. The way classic MacOS