I've used xlrd. It's pretty straightforward and Excel 2007 is in the works...
Here's the main Google Group for both projects: http://groups.google.com/group/python-excel Keyton On Nov 13, 10:44 pm, Tim Chase <[EMAIL PROTECTED]> wrote: > >> [my stuff about using XML templates with Excel] > > Not trying to start a flame war, but pyexcelerator/xlwt support these > > as well... > > No flame-war perceived...just sharing the hack I've used that > doesn't involve much more complexity than a prefab template and > Django's built-in templating. > > [Steve & Matt dialoging] > > >> I think Tim's point is that with XML you can use Excel visually to > >> create the spreadsheet you want, then use Django's existing template > >> mechanism to tailor the output as required. It struck me as a very neat > >> solution to the problem posed. > > > Good point, I didn't catch it on my way through ;) Though I've heard > > of people doing similar XML manipulation after someone (good with > > design) does layout in OpenOffice, and then exporting to (ms) office. > > I don't know if it's easy to reverse engineer the format of more > complex documents -- my aim was merely to reverse enough of the > format to export the data I wanted in a more preserving fashion. > For my simple data-dumps, it was good. For complex > fixed-dimension Excel files, it would also likely serve well (as > a matter of fact, you can just put values like "{{ obj.field }}" > in your cells). But for more complex layouts that also need to > dynamically grow rows or columns, something more domain-specific > like Matt mentions will likely cause less headache. However, MS > does offer reference materials on the format[1] > > > Is the 2K3 xml format supported by other versions of Office? > > I don't know how far back it's readable -- I've got O2k3 on my > office development machine, and others in the office with 02k7 > have no problems opening the export files. I don't have access > to pre-'03 versions for testing. From what I've read, it works > in "Excel 2002" (such a creature exists?) > > -tim > > [1]http://msdn.microsoft.com/en-us/library/aa140066.aspx --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
