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
-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 of data
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
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
[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...
1. If this is data
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
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