>> [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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---
