PyAtl Oct 2009: "Adding Excel-based Import and Export to Django" by Keyton Weissinger


End users often need to update multiple items at one time. Unfortunately, building a grid-like user interface in a webpage to allow for this type of editing is often painful and results in a poor substitute for Excel, the standard against which some of these same end users will compare it. Why not just let 'em use Excel?


"In this presentation I will talk about a simple addition to any django application that will allow your end users to, in essence, check out a large number of items, update them en masse using Excel (where they can take the data offline and sort to their heart's content), and then check them all in again.

"This same system also allows for Excel-based batch import -- an added bonus. And, of course, it works if you're spreadsheet of choice is Open Office as well.

"This presentation shows you how to add this functionality to any django project quickly and easily using some simple model decoration, an openly available drop-in reusable django application and the excellent libraries xlrd and xlwt."