[python-win32] Writing to Excel performance

Dominick Lauzon Dominick.Lauzon at MSCsoftware.com
Fri Dec 12 15:54:27 CET 2008


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 accumulate the data and push it to Excel all at
once or any other way to improve performance altogether ?

 

Any guidance would be appreciated.

 

 

Domnick Lauzon

 

 

 

 

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-win32/attachments/20081212/f66d5b1f/attachment.htm>


More information about the python-win32 mailing list