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

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

Re: [python-win32] Writing to Excel performance

2008-12-12 Thread Dahlstrom, Roger
python.org [mailto:python-win32-bounces+rdahlstrom=directedge@python.org] On Behalf Of Tim Roberts Sent: Friday, December 12, 2008 1:24 PM To: Python-Win32 List Subject: Re: [python-win32] Writing to Excel performance Dahlstrom, Roger wrote: > Couple of tricks I've used with some success...

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

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 t

Re: [python-win32] Writing to Excel performance

2008-12-12 Thread Dahlstrom, Roger
thon-win32-bounces+rdahlstrom=directedge@python.org [mailto:python-win32-bounces+rdahlstrom=directedge@python.org] On Behalf Of Dominick Lauzon Sent: Friday, December 12, 2008 9:54 AM To: python-win32@python.org Subject: [python-win32] Writing to Excel performance Hi, I have large matrices

[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 accumulat