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
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.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...
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
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
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
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