Comments on: Hacking xlwt http://blog.insightvr.com/?p=30 lasers, wiimote headtracking, games, visualizations Sun, 22 Aug 2010 21:30:51 +0000 hourly 1 http://wordpress.org/?v=3.0.1 By: Chris Withers http://blog.insightvr.com/?p=30&cpage=1#comment-15455 Chris Withers Thu, 18 Mar 2010 16:20:54 +0000 http://blog.insightvr.com/?p=30#comment-15455 Sunku: you could always read the docs. ws.flush_row_data() has been around for quite a while now! Sunku: you could always read the docs.

ws.flush_row_data() has been around for quite a while now!

]]> By: Sunku Ranagnath http://blog.insightvr.com/?p=30&cpage=1#comment-15444 Sunku Ranagnath Wed, 17 Mar 2010 18:08:29 +0000 http://blog.insightvr.com/?p=30#comment-15444 I am using the xlwt version 0.7.2 (latest that I could get now) and it still have the same problem. But great to see the work around after spending ton of time looking for alternative, being a python newbie! Thanks John! Their should be a way to have this blog appear on top of the Google results, so thats its easier for people! I am using the xlwt version 0.7.2 (latest that I could get now) and it still have the same problem. But great to see the work around after spending ton of time looking for alternative, being a python newbie! Thanks John!

Their should be a way to have this blog appear on top of the Google results, so thats its easier for people!

]]> By: parxier http://blog.insightvr.com/?p=30&cpage=1#comment-14380 parxier Sun, 15 Nov 2009 22:32:43 +0000 http://blog.insightvr.com/?p=30#comment-14380 Oh, thank you so much! I managed to shorten xls generation from by almost 50%! Fantastic! Oh, thank you so much! I managed to shorten xls generation from by almost 50%! Fantastic!

]]> By: Georg http://blog.insightvr.com/?p=30&cpage=1#comment-8044 Georg Sat, 13 Jun 2009 20:34:13 +0000 http://blog.insightvr.com/?p=30#comment-8044 I had the same memory problem for my big Excel fine. John you rock! I had the same memory problem for my big Excel fine.
John you rock!

]]> By: john http://blog.insightvr.com/?p=30&cpage=1#comment-7622 john Wed, 03 Jun 2009 03:51:54 +0000 http://blog.insightvr.com/?p=30#comment-7622 Chris, Sorry to have not updated my post. Of the three changes I made, one has been incorporated into xlwt. I'm working on the other two, but it still isn't clear if they'll be accepted or not. I have probably not been the the best contributor ever, but contributing to xlwt has been an interesting experience to say the least. Chris,

Sorry to have not updated my post.

Of the three changes I made, one has been incorporated into xlwt. I’m working on the other two, but it still isn’t clear if they’ll be accepted or not.

I have probably not been the the best contributor ever, but contributing to xlwt has been an interesting experience to say the least.

]]> By: Chris Withers http://blog.insightvr.com/?p=30&cpage=1#comment-7249 Chris Withers Fri, 29 May 2009 16:24:19 +0000 http://blog.insightvr.com/?p=30#comment-7249 It's a shame that John didn't follow up here to point out that his patch has been incorportated and is in the latest released version of xlwt. It would be interesting to get to the bottom of the perceived speed issues... It’s a shame that John didn’t follow up here to point out that his patch has been incorportated and is in the latest released version of xlwt.

It would be interesting to get to the bottom of the perceived speed issues…

]]> By: graeme http://blog.insightvr.com/?p=30&cpage=1#comment-1369 graeme Sun, 12 Oct 2008 19:22:57 +0000 http://blog.insightvr.com/?p=30#comment-1369 I can imagine psycho uses a hell of a lot of memory, that is what the h must stand for, HELL. It's pysco not psycho I can imagine psycho uses a hell of a lot of memory, that is what the h must stand for, HELL. It’s pysco not psycho

]]> By: john http://blog.insightvr.com/?p=30&cpage=1#comment-1342 john Tue, 07 Oct 2008 16:17:15 +0000 http://blog.insightvr.com/?p=30#comment-1342 DKL, Our site is done in Python, so that's what we're using. xlwt has some shortcomings, but has worked well for what we use it for. It does formatting including row/column sizing, cell background color, text color, font control, cell borders and cell merging. With my hacks you can also specify print areas if you want. As for size of exports, the 100,000 row test listed in this post comes in at 28.8 MB. I've done exports that are hundreds of megabytes. At this point the primary shortcoming of xlwt in my mind is speed. It is possible that I could speed things up using psycho, but that would cause a memory tradeoff that I'm unwilling to make at this point. DKL,

Our site is done in Python, so that’s what we’re using. xlwt has some shortcomings, but has worked well for what we use it for. It does formatting including row/column sizing, cell background color, text color, font control, cell borders and cell merging. With my hacks you can also specify print areas if you want.

As for size of exports, the 100,000 row test listed in this post comes in at 28.8 MB. I’ve done exports that are hundreds of megabytes.

At this point the primary shortcoming of xlwt in my mind is speed. It is possible that I could speed things up using psycho, but that would cause a memory tradeoff that I’m unwilling to make at this point.

]]> By: DKL http://blog.insightvr.com/?p=30&cpage=1#comment-1338 DKL Tue, 07 Oct 2008 03:32:13 +0000 http://blog.insightvr.com/?p=30#comment-1338 I'd just use Java, which has a variety of rhobust, enterprise-ready Excel API's. A very good one is included as part of the Pentaho BI interface. I've used an Excel implementations in Ruby, which was just a port of the Perl package that handles Excel files. This is good enough for Perl, but so is just about everything -- Perl is the language of "good enough" Add to this that the ports of the Perl package are several versions old, and you have into all kinds of issues. Aside from miscellaneous bugs, it didn't handle files over 6MB in size, and didn't have robust formatting options. Please tell me that the Python version is better. I’d just use Java, which has a variety of rhobust, enterprise-ready Excel API’s. A very good one is included as part of the Pentaho BI interface.

I’ve used an Excel implementations in Ruby, which was just a port of the Perl package that handles Excel files. This is good enough for Perl, but so is just about everything — Perl is the language of “good enough” Add to this that the ports of the Perl package are several versions old, and you have into all kinds of issues. Aside from miscellaneous bugs, it didn’t handle files over 6MB in size, and didn’t have robust formatting options.

Please tell me that the Python version is better.

]]>