> I have many pages to be exported to the excel sheet. I use django and > javascript. > i use pagination. Can any one help me out ?
Just create a custom view that returns apropos content/headers. There are several ways of exporting files that Excel can read. CSV files: ========== +easy to make templates for or use the python "csv" module +fairly universal access +simple mime-type of text/csv -can't control formatting -no support for multiple tabs/pages (we hacked this problem by zipping multiple .csv files) -multiple "flavors" so you have to choose your escaping/quoting rules; however there are some common conventions like "Excel" that the CSV module facilitates Native XLS files: ================= +gives you "the real thing" +simple mime-type -requires an add-on module like xlwt or PyExcelerator Office 2k3 "XML Spreadsheet" format: ==================================== +gives you much more control over formatting +supports multiple tabs +pretty easy to reverse-engineer for simple documents -doesn't work with certain versions of Excel -it's not really a standard -not sure whether it works with OpenOffice.org/Gnumeric/KOffice -raw format is very verbose, but a good candidate for compression -getting Excel to open them requires a little mime-type hackery in IE & FireFox The new O2k7 abomination's format: ================================== +you get the latest and greatest from MS -it's not really a standard -it's ugly -it's a pain -it's only supported 100% by O2k7 -it peeves people (can you tell I've not seriously entertained implementing this option because there are so many minuses to it) From our experience, if you don't need formatting or need universal access, use CSV. If you need formatting, we opted for the "Office 2k3 XML Spreadsheet" for our purposes because it was the fastest route to a solution for us. There have been pretty lengthy discussions on the list which I've been involved in, so here's a query that gets you some past discussions: http://groups.google.com/group/django-users/search?q=excel+csv+xml+tim+chase&group=django-users Hope this helps, -tim --~--~---------~--~----~------------~-------~--~----~ 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 django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
